Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
I am trying to add a number column that restarts counting every time a new category starts.
Example:
Cat CustomColumn
A 1
A 2
A 3
B 1
B 2
B 3
C 1
C 2
C 3
In Excel, this is very easy, but in Power Query I have a hard time achieving this.
Any ideas?
Thanks,
Kirvis
Solved! Go to Solution.
Hi,
you can achieve this with the grouping function and then index it.
A nice Article about it is her.
https://www.excelguru.ca/blog/2018/06/27/number-rows-by-group-using-power-query/
-------------------------------------------------------------------
Did I answer your question? Mark my post as a solution!
It was useful? Press Thumbs Up!
Hi,
you can achieve this with the grouping function and then index it.
A nice Article about it is her.
https://www.excelguru.ca/blog/2018/06/27/number-rows-by-group-using-power-query/
-------------------------------------------------------------------
Did I answer your question? Mark my post as a solution!
It was useful? Press Thumbs Up!