Index incrementation inside a group of values. Power Query

[D3K]

Hey Everyone!

Can't figure it out, how to find a solution for the next case. 

We got a list of invoices, that content one or a few items inside.

And then we number a rows with INVOICES. If invoice has more then one record, it's number repeats.

The question is how to add such column in POWER QUERY (column B on the image), that will contain kind of internal index for every invoice? And it has to be started from 20 and increments by 20 for every next row.

New invoice - countintg starts from 20 again.

Please the image below

Any help will be highly appresiated! Thanks a lot!

 

[amitchandak · Accepted solution]

@D3K , refer to the blog on the same topic.

https://radacad.com/create-row-number-for-each-group-in-power-bi-using-power-query

[D3K]

@amitchandak @MahyarTF 
Thanks a lot! Exactly what I need! 👍

[MahyarTF · Accepted solution]

Hi,

You could use the article from Radcad :
https://radacad.com/create-row-number-for-each-group-in-power-bi-using-power-query

If you want to start from 20 and increment by 20 use below M query in Add Custom column section :
Table.AddIndexColumn([Count], "Index", 20, 20)

[amitchandak · Accepted solution]

@D3K , refer to the blog on the same topic.

https://radacad.com/create-row-number-for-each-group-in-power-bi-using-power-query

[DHPaul]

Been a while since I have had to do this, thanks for the reminder!