Forum Discussion
Solved
Get & Transform . How to write Cumulative Count with M language or within PowerQuery
Hi Folks, I'm looking to do cumulative count within PowerQuery so i can use that particular column and Pivot it as a header. Below in the sample Data before any queries. ...
This is the same like a nested index. Please check if this video helps: https://www.youtube.com/watch?v=-3KFZaYImEY
You would group on column "Product | Category" and the added Index would be your cumulative count.
This is the same like a nested index. Please check if this video helps: https://www.youtube.com/watch?v=-3KFZaYImEY
You would group on column "Product | Category" and the added Index would be your cumulative count.
Yes, This work like a charm :) I guess i didnt understand the grouping function as i only Group based on 1 of column :)
