Need help with Cumulative Count in PowerQuery

[Iloveexcel&excelloveme]

Hi Folks,

I need some help to write a formula for cumulative count within PowerQuery, is just like Countif in excel. I can't do it in Excel as I've more than 500k of data

• 

This is the sample data


I need to do a cumulative count, using "Product | Category" as the criteria. The above is what i wanna achieve with " Column Header"

Appreciate any help I've attached the original file for reference

 

[Comfy]

Is the column concatenation mandatory?

You can group by all four columns to return a count.

 

[Iloveexcel&excelloveme]

Thanks Comfy,
I can't Group all 4 as I need to Pivot "ProductID | Description".
And i tried it earlier in the morning but it returned the sum count(e.g. 2) instead of a running order(e.g. 1,2,3). I need the running order as that will be the column header for "ProductID | Description"

This is the end result i wanna achieve

 

[Comfy]

Oops my mistake, forgot to add an additional step.

I've attached the correct one.

 

[Comfy]

All you will need to do is add a step to change the column Types (ID will need to be whole number)

Then you'll be able to pivot.

 

[Iloveexcel&excelloveme]

Solved

Yes, this work like a charm, i did some slight changes to fit my dataset