Forum Discussion

ccakjcrx's avatar
ccakjcrx
Resolver I
8 years ago
Solved

Rank Date

Hello!   I'm trying to brake my bad habit of adding columns to arrive at a desired outcome, and instead create measures when possible.   I believe this is a fairly simple problem, but I cannot so...
Need Help
Tips and Tricks
Tutorial Requests
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Hi ccakjcrx

     

    Try this MEASURE

     

    Index =
RANKX (
    ALLSELECTED ( Sheet1[Month Year] ),
    CALCULATE ( SELECTEDVALUE ( Sheet1[Month Year] ) ),
    ,
    ASC
)
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi ccakjcrx,

 

If you column stored the normal date value, you can try to use below measure to calculate the rank as the index:

Index =
COUNTX (
    FILTER ( ALL ( Table ), [Month Year] <= MAX ( [Month Year] ) ),
    [Month Year]
)

Regards,

Xiaoxin Sheng

ccakjcrx's avatar
ccakjcrx
Resolver I
8 years ago

Anonymous

 

Hey!

 

Thanks for helping me out.

 

I applied your measure, but got the 14 for each row--rather than showing 1 for the first row, 2 for the second row, etc. You can download my .pbix file HERE

 

 

 

 

 

 

 

 

 

 

 

 

 

I want to do this in a MEASURE, but I'm not sure it is possible :(

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    8 years ago

    Hi ccakjcrx

     

    Try this MEASURE

     

    Index =
RANKX (
    ALLSELECTED ( Sheet1[Month Year] ),
    CALCULATE ( SELECTEDVALUE ( Sheet1[Month Year] ) ),
    ,
    ASC
)
    • ccakjcrx's avatar
      ccakjcrx
      Resolver I
      8 years ago

      Zubair_Muhammad

       

      Hey! 

       

      That works like a charm. Thank you very much!!!

    • Piyush_Ghungrud's avatar
      Piyush_Ghungrud
      Helper I
      3 years ago

      Hi Zubair_Muhammad ,

      I have tried this, but this does gives the desired ranking.

      Please refer the image below

      Please, let me know your valuable suggestions.
      Thank you 🙂