Forum Discussion
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 the 1st label, i.e. when a date rank below is 1, but not for the others. Is there anything obviously wrong with the DAX expressions I'm using?
Date Rank measure
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)
1 Reply
- Peter_Resolver I
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)