Index column based on duplicates

Question

Hi,&nbsp;I'd like to create an index column following the example below :IDDATEINDEXA2021-01-141B2021-01-152C2021-01-152D2021-01-152E2021-01-163F2021-01-163If the date is the same than the previous row, keep the same index.If the date is different of the previous one, increment index.&nbsp;Does someone knows how to do that with Power Query ?&nbsp;Thanks in advanceBest regards,Cado

hotchilli · Accepted Answer

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).
--
&nbsp;
Let me know how it goes

Forum Discussion

Related content

Fixed Index Column

Filter a column with duplicate values based on the highest Index value

dummy index column

Column index

How to Count Duplicated row?(Distinct Column? Index Column?)