Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
Solved! Go to 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.
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-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.
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Yes, This work like a charm 🙂 I guess i didnt understand the grouping function as i only Group based on 1 of column 🙂
User | Count |
---|---|
128 | |
72 | |
70 | |
58 | |
53 |
User | Count |
---|---|
192 | |
96 | |
67 | |
64 | |
54 |