Forum Discussion
Solved
ranking duplicates
Hi, I'm looking for a way to 'rank duplicates'. Basically in a simplified way I have data per customer for differen periods, and I want to rank data based on a combination of this. I can best ex...
Good points! Giving me the idea of a nice DAX-only solution, that would work in PP as well (Unique row identifier is essential here) ;-)
RANKX(FILTER(table1; table1[Code]=EARLIER(table1[Code]));[Unique ID];;1)
This looks like a nested index. Have a look how this goes here: https://blog.crossjoin.co.uk/2015/05/11/nested-calculations-in-power-query/
