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.
I am currently trying to create a measure that calculates yesterday's sales amount, relative to any date I pass through my Date slicer. The syntax reads as follows:
Solved! Go to Solution.
I figured this out. I just replaced PARALLELPERIOD with DATEADD and the measure calculated properly. I'm still interested in why DAY cannt be used as an interval but effectively, it doesn't matter for this exercise.
I figured this out. I just replaced PARALLELPERIOD with DATEADD and the measure calculated properly. I'm still interested in why DAY cannt be used as an interval but effectively, it doesn't matter for this exercise.
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |