Hi All,
Is there any way we can Group By in Power Query at every change in Column Value ?
Appreciate your help.
Hi All,
Is there any way we can Group By in Power Query at every change in Column Value ?
Appreciate your help.
Yes, you can. How exactly will depend on the data ... Sample, please!
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Sample Data Attached, We need group by each change in "Amount"
What does your required output look like for that data sample?
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Group All Rows of the Table (which should be in Column 2), & Column 1 Output will be:
5.5
6
7
6
5.5
This does what you want:
Please Login or Register to view this content.
Thanks a lot. Learned something new today from you : )
Create Lists and merge with the table, Great Idea !
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. You may also 'Add Reputation' to those who helped you.
Thanks I have done that.
Would you like to have a look at my thread (link below), its marked solved, but if you have some ideas to make it fast ? the solution provided consumes a lot of time to process the query.
https://www.excelforum.com/excel-gen...ml#post5239145
Last edited by ibuhary; 12-15-2019 at 04:34 AM. Reason: to conform forum rules
If you want people to look at the other thread, you need to remove the solved tag. You should not, however, be pestering members in this way: any help offered is entirely discretionary and completely free. Please do not try to put pressure on the membership in this way. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks