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
)
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
)
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 🙂