Forum Discussion
Solved
RankX 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)
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)
awesome you are a genius, the issue came up because of ALL functions. I removed it based on your advice & it fixed the issue