Get & Transform . How to write Cumulative Count with M language or within PowerQuery

[Rookarumba]

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.

I managed to merge Product & Category, Product ID & Product Description with " | " as the delimiter.
Then I created an extra column "Column Header" as the Header to Pivot as the Column Header for " Product ID & Product Description".
In excel the formula will be like =COUNTIF(M$4:M4,M4) to get a cumulative count for "Product & Category"
Column M is "Product | Category "

I'm hoping someone can help me out with the formula cumulative count within PowerQuery, using "Product | Category" as the criteria.

[ImkeF · Accepted solution]

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.

[Rookarumba]

Yes, This work like a charm 🙂 I guess i didnt understand the grouping function as i only Group based on 1 of column 🙂