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 all,
I'm trying to create a measure which will return the previous month of a number of other measures relative to the current period from my dimDate table.
So for example - return Feb-17 when the dimDate is filtered for Mar-17. Is this possible within a switch function or is there a better way to achieve this?
Thanks
Solved! Go to Solution.
you could use dateadd, create a measure and
ie dateadd(date[date],-1, month)
Proud to be a Super User!
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 |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |