Forum Discussion
PaulDBrown
Community Champion
Community ChampionCalculated column for RANK by product and person
Good morning, Can someone help me with this? I am trying to create a calculated column which creates a rank based on product by sales person. The rank itself establishes the order by date. In oth...
hi PaulDBrown
For this case, you could use EARLIER Function in the formula as below:
Column 2 = RANKX(FILTER('Table','Table'[Sales Person]=EARLIER('Table'[Sales Person])),'Table'[Min date Product and sales person],,ASC,Dense)https://docs.microsoft.com/en-us/dax/earlier-function-dax
Regards,
Lin
PaulDBrownCommunity Champion
Community ChampionAnonymous
Thanks a million! worked like a charm!
v-lili6-msft
Community Support
Community Supporthi PaulDBrown
For this case, you could use EARLIER Function in the formula as below:
Column 2 =
RANKX(FILTER('Table','Table'[Sales Person]=EARLIER('Table'[Sales Person])),'Table'[Min date Product and sales person],,ASC,Dense)https://docs.microsoft.com/en-us/dax/earlier-function-dax
Regards,
Lin