Forum Discussion
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 solve it: I simply want a MEASURE to rank the dates in the following table visual (you can access the pbix and data file HERE):
I simply want to add a MEASURE that 'ranks' these in ascending order. I tried to use both COUNTROWS and RANKX, but could not produce the outcome I'm looking for. In the end, I want the measure to be added to the table visual, and populate a value to the right of each date that ranks each respective date.
I think this logic is what I'm after: I want the measure to iterate through the list, and compare each row to the MIN date in the row, and COUNT that row--adding to the count each time that condition is TRUE.
Thanks for the consideration.
Hi ccakjcrx
Try this MEASURE
Index = RANKX ( ALLSELECTED ( Sheet1[Month Year] ), CALCULATE ( SELECTEDVALUE ( Sheet1[Month Year] ) ), , ASC )
7 Replies
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
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
