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

miltenburger

 

HEY!

 

Thanks for responding. I probably should have included this in my original post. 

 

This is the outcome I am looking for:

 

An index value would accomplish this, but I don't know how to get this via a MEASURE

 

 

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