Forum Discussion
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
why in the 2nd screenshot the rankx formula is not giving the correct result, it should start from 1?
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)
2 Replies
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
