Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
srivally
Helper I
Helper I

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

1 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

View solution in original post

3 REPLIES 3
v-yulgu-msft
Employee
Employee

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.

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

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.