Forum Discussion
Ranking
Hello, I finally found the solution here. This is exactly what I was looking for. But thank you for your help trying very quickly.
https://radacad.com/create-row-number-for-each-group-in-power-bi-using-power-query
Hello, here is the link. I just uploaded new table to your template. My wishful state ist to have new column having numbers 1,2,3 for each row within the customer ID (For example C01 will have numbers 1-5 because he has 5 different contacts).
Hi, dmatliak
Thank you for sharing.
I am not sure still whether I understood your question correctly.
I assume you want to have an index column per each client ID.
I think you are right and using RANKX function is one of many ways to create the index column.
However, by seeing the sample that is given by you, I thought I could not use RANKX, because there were no columns that can be ranked row by row.
So, I had no choice but to use Power Query.
I created a new table, and you can see this table inside the Power Query how the steps are to create the index column.
If you have a column that can be ranked, for instance, date column, then I can try to create it not by Power Query.