Reply
hassanh2
Helper I
Helper I
Partially syndicated - Outbound

Rank Customers by Order Date

Hello,

 

Can someone please help with the following - I need to Rank Customer ID by SalesDate Desc.
The Fact table I have has more than 10K customers and each has multiple sales records in the same day. Same day sales shall be ranked the same rank. 

hassanh2_0-1695704203652.png

 

2 ACCEPTED SOLUTIONS
Ritaf1983
Super User
Super User

Syndicated - Outbound

Hi @hassanh2 
You can add calculated column with DAX Formula:

RankDate =
RANKX(
    FILTER(
        'table',
        'table'[Customer] = EARLIER('table'[Customer])
    ),
    'table'[Date],
    ,
    DESC
)
The sample file is Linked here 
 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

Syndicated - Outbound

Hi @hassanh2 
Did you download my linked file?
I checked it again now, and the results are correct...

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

3 REPLIES 3
hassanh2
Helper I
Helper I

Syndicated - Outbound

Hi @Ritaf1983 
Thank you for your support, but unfortunately the DAX you sent didnt return the result what I was looking for. In some cases the rank started from 2, also sometimes the rank was not consistent 1,2,4,7,...etc. I tried by adding Dense to your DAX but still didn't solve the issue.

Ritaf1983
Super User
Super User

Syndicated - Outbound

Hi @hassanh2 
You can add calculated column with DAX Formula:

RankDate =
RANKX(
    FILTER(
        'table',
        'table'[Customer] = EARLIER('table'[Customer])
    ),
    'table'[Date],
    ,
    DESC
)
The sample file is Linked here 
 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Syndicated - Outbound

Hi @hassanh2 
Did you download my linked file?
I checked it again now, and the results are correct...

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile
avatar user

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)