Blog Post

Power BI Community Blog
3 MIN READ

How to do cumulative counting by group in Power Query

Anonymous's avatar
Anonymous
Not applicable
4 years ago
In this article, I will introduce two scenarios for cumulative counts in Power Query. Scenario 1 is to perform grouping and accumulative counting according to other columns. Scenario 2 is an advanced...
Updated 4 years ago
Version 2.0
Power Query
Support insights
Tips&Tricks
Anonymous's avatar
Power BI Community Blog
On this blog you will find articles, guides and information created by our community members and, from time to time, roundups and community news. If you are interested in becoming a community blog author, send a private message to Natalie_iTalent. An overview of the community blogs can be found here.
PeraZo's avatar
PeraZo
Icon for Helper I rankHelper I
2 years ago

Hello Anonymous 

 

Thank you for clear explanation.

I tried this method on my dataset and is working.

 

One question is what is the below syntax means where you wrote as below?

(r) =>

 

I am pretty new to the Power Query, SQL and wanted to learn for my experience.

 

Thank you for support.