Forum Discussion
Solved
Error using the 'DAY' interval in my PARALLELPERIOD() function
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: Yesterday's Sales = CALCULA...
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.