Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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:
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:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |