RankX formula issue

[vjnvinod]

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?

[amitchandak · Accepted solution]

@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]

@amitchandak 

awesome you are a genius, the issue came up because of ALL functions. I removed it based on your advice & it fixed the issue