Reply
Highlighted
Regular Visitor
Posts: 17
Registered: ‎07-19-2018
Accepted Solution

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

link and the rank which I wanted to display. 

 

Regards,

Srivalli


Accepted Solutions
Regular Visitor
Posts: 17
Registered: ‎07-19-2018

Re: Rank customers

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

View solution in original post


All Replies
Community Support Team
Posts: 5,694
Registered: ‎09-21-2016

Re: Rank customers

Hi @srivally,

 

DAX for calculated column [Rank].

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

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Regular Visitor
Posts: 17
Registered: ‎07-19-2018

Re: Rank customers

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

Regular Visitor
Posts: 17
Registered: ‎07-19-2018

Re: Rank customers

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