Forum Discussion

srivally's avatar
srivally
Helper I
7 years ago
Solved

Rank customers

Hi All,   I want to rank the customers based on Year and Month. I have tried many cases but not worked out. Could you please help me on this. I have attached the excel file  in the https://www.dro...
Need Help
  • srivally's avatar
    srivally
    7 years ago

    I got the solution. I have created the measure with that query earlier. Instead of creating measure, if we create a column with the same query, it's working.
    Thank you v-yulgu-msft

     

    Regards,

    Srivalli

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

Hi srivally,

 

DAX for calculated column [Rank].

Rank =
RANKX (
    FILTER ( Sheet1, Sheet1[Customers] = EARLIER ( Sheet1[Customers] ) ),
    Sheet1[Balance],
    ,
    DESC,
    DENSE
)

Best regards,

Yuliana Gu

  • srivally's avatar
    srivally
    Helper I
    7 years ago

    I got the solution. I have created the measure with that query earlier. Instead of creating measure, if we create a column with the same query, it's working.
    Thank you v-yulgu-msft

     

    Regards,

    Srivalli