Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

RANKX by date

I'm trying to rank some records by the date, but I'm getting rather unexpected results. Here's my column formula:       But here's the result I'm getting:  
Need Help
  • Icey's avatar
    Icey
    6 years ago

    Hi Anonymous ,

    When I use your expression to create a column, it returns "1" for each row. But, when use it to create a measure, it works well.

    If you want to create a column, try this:

    Date Rank Index 2 column = RANKX ( 'award', 'award'[award_begin_date],, DESC )

     

     

    Best Regards,
    Icey

     

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

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
2 years ago

Hi,

Replace CALCULATE with RANKX

WaldemarVogt's avatar
WaldemarVogt
Regular Visitor
2 years ago

Oh how I didn't notice it! Thank you so much. 

If you allow I have one more question, is there a way to reverse columns order with dates by having this measure created? Don't really know how to do this.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    2 years ago

    You are welcome.  I do not understand your question.

    • WaldemarVogt's avatar
      WaldemarVogt
      Regular Visitor
      2 years ago

      So I would like to change the order of columns, the first column should be 4/1/2024 and the last should be 1/1/2024. I was thinking that creating this measure with rank could help me, but still no idea how to manage it. Hope it's more clear now.