Hey, I Searched for a solution all over the forum, there are some similar but i did not figure out how to do it correctly.
What I'm trying to do is to add an index column, which tells me the row number for the CustIt. I've already sorted the data by date (Descending), and now i'm trying to add the column.
I've marked in red what i meant.
Thanks for your help!
Go to Solution.
Table.AddIndexColumn([Whatever You Named the Column in the Prev Step], "Index", 1, 1)
View solution in original post
@Anonymous Thank you!
this article gives an example how to do it:https://www.excelguru.ca/blog/2018/06/27/number-rows-by-group-using-power-query/
Proud to be a Super User!
Click here to learn more about the September 2022 updates!
Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.
Watch Session 25 of Ted's Dev Camp.