Index column based on duplicates

[Anonymous]

Hi,

I'd like to create an index column following the example below :

ID	DATE	INDEX
A	2021-01-14	1
B	2021-01-15	2
C	2021-01-15	2
D	2021-01-15	2
E	2021-01-16	3
F	2021-01-16	3

If the date is the same than the previous row, keep the same index.

If the date is different of the previous one, increment index.

Does someone knows how to do that with Power Query ?

Thanks in advance

Best regards,

Cado

[HotChilli · Accepted solution]

Make a table that just includes the date column .

Remove Duplicates.

Add Index Column.

---

Merge the 2 tables based on the date (returning the index column to the original table).

--

Let me know how it goes

[Anonymous]

Hi @HotChilli 

Thanks for your help, it works perfectly !

Have a nice day,

Cado