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

Question

Hi Folks,&nbsp;I'm looking to do cumulative count within PowerQuery so i can use that particular column and Pivot it as a header.&nbsp;Below in the sample Data before any queries.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;I managed to merge Product &amp; Category, Product ID &amp; 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 &amp; Product Description".In excel the formula will be like =COUNTIF(M$4:M4,M4) to get a cumulative count for "Product &amp; Category"Column M is "Product | Category "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;I'm hoping someone can help me out with the formula cumulative count within PowerQuery, using "Product | Category" as the criteria.

imkef · Accepted Answer

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.

Forum Discussion

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

2 Replies

Related content

PowerQuery transformation

PowerQuery transform rows

Transform measure in cumulative measure

Table Transformation

Cumulative Total