Forum Discussion

hassanh2's avatar
hassanh2
Helper I
2 years ago
Solved

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 sam...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    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.

  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

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

Ritaf1983's avatar
Ritaf1983
Super User
2 years ago

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.

  • Ritaf1983's avatar
    Ritaf1983
    Super User
    2 years ago

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