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!
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.