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