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