Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
kirvis
Helper I
Helper I

Add column that restarts counting for each new category

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

 

1 ACCEPTED SOLUTION
rainer1
Resolver III
Resolver III

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!

View solution in original post

2 REPLIES 2
rainer1
Resolver III
Resolver III

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!

Ah yes, excellent! That is exactly what I needed!

Thanks!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors