Forum Discussion
vjnvinod
Impactful Individual
Impactful IndividualRankX formula issue
hi Experts, i am getting 2 different results for the RankX function first screenshot same details, rank starts from 1 The second screenshot same details, rank starts from 2 ...
vjnvinod , Are these two same tables?
sort on week start date and check for min one. Also if there is any blank value, the rank may start with 2.
Also, there no need of all('Date') in column rank
you can use
Rankx('Date', [week start],,asc,dense)
amitchandak
Super User
Super Uservjnvinod , Are these two same tables?
sort on week start date and check for min one. Also if there is any blank value, the rank may start with 2.
Also, there no need of all('Date') in column rank
you can use
Rankx('Date', [week start],,asc,dense)
vjnvinodImpactful Individual
Impactful Individual
awesome you are a genius, the issue came up because of ALL functions. I removed it based on your advice & it fixed the issue