Forum Discussion

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

Tips and Tricks

Tutorial Requests

Zubair_Muhammad

8 years ago

Try this MEASURE

Index =
RANKX (
    ALLSELECTED ( Sheet1[Month Year] ),
    CALCULATE ( SELECTEDVALUE ( Sheet1[Month Year] ) ),
    ,
    ASC
)

Helper V

8 years ago

is this what you want?

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
  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
    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 :(