Forum Discussion
Solved
Filter on Date Rank Measure
Hi, I'm trying to create measures which give me 1st, 2nd, 3rd date labels from the latest available date going back and it should depend on dates selected in a date range slicer. This works for t...
With a help from http://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures and experimentation via CONCATENATEX to see what values are being passed through the Calculate wasn't the way to go to implement this. Following measure does what I want:
[Date[Rank 1]] Label] = "as of " & UNICHAR(10) & FILTER(ALLSELECTED(Table[Aggregation Date]), [Date Rank] = 1)
With a help from http://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures and experimentation via CONCATENATEX to see what values are being passed through the Calculate wasn't the way to go to implement this. Following measure does what I want:
[Date[Rank 1]] Label] = "as of " & UNICHAR(10) & FILTER(ALLSELECTED(Table[Aggregation Date]), [Date Rank] = 1)