Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Rank Orders based on Date

Hi all,   I have the following dilemma:   I am trying to create a calculated column that would show me (based on the date of the order), the rank of that order for the specific customer. Example...
Need Help
Show and Tell
  • PattemManohar's avatar
    PattemManohar
    7 years ago

    Anonymous Please try this as a "New Column"

     

    Rank = RANKX(FILTER(Test114Rnk,Test114Rnk[Customer]=EARLIER(Test114Rnk[Customer])),[Date],,ASC,Dense)

PattemManohar's avatar
PattemManohar
Community Champion
7 years ago

Anonymous Please try this as a "New Column"

 

Rank = RANKX(FILTER(Test114Rnk,Test114Rnk[Customer]=EARLIER(Test114Rnk[Customer])),[Date],,ASC,Dense)

ozne99's avatar
ozne99
Frequent Visitor
6 years ago

Is it possible for this to be dynamic, based on the date filter? For example, how do we get it to recalculate the rank of the customer using a date slicer?