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.
Hey,
I have a SWITCH fucntion that is working for everything but "Total Hours (Previous 30 Days)", I'm presuming this is due to the way I've written the DAX for this measure as opposed to the others, the problem is that when I select the "Total Hours (Previous 30 Days)" option, some of my visuals don't display (The ones that are linked to other tables), If I just load the measure on it's own, then it works, so it's something to do with the way I've written the DAX that is preventing me using other tables fo visualisation.
Solved! Go to Solution.
@magnify-bi-com , Try like this
Rolling 30 = CALCULATE([Total Hours],DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-30,DAY))
@magnify-bi-com , Try like this
Rolling 30 = CALCULATE([Total Hours],DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-30,DAY))
Thanks Amit, foolishly, I think I just needed to change my MINs to MAXs, that seems to have done the trick.
But your soltuion worked also.
Thanks,
Jon
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 |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |