Rank customers

[srivally]

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.dropbox.com/s/qmi7aylbqc3bred/Rank%20Sample.xlsx?dl=0

link and the rank which I wanted to display. 

Regards,

Srivalli

[v-yulgu-msft]

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]

Hi @v-yulgu-msft,

I have tried the same DAX query, but I'm facing the error attached.
https://www.dropbox.com/s/37u9pzufgv5klqr/Error.PNG?dl=0

Regards,

Srivalli

[srivally · Accepted solution]

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