Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
Table.AddIndexColumn([Whatever You Named the Column in the Prev Step], "Index", 1, 1)
Table.AddIndexColumn([Whatever You Named the Column in the Prev Step], "Index", 1, 1)
@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/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
54 | |
21 | |
12 | |
11 |