Forum Discussion
Dateadd does not work in DAX in variable
Dear all
I have this formula
You have to pass a measure that select a different measure different by case (not a variable).
Something like this:
MEASURE SWITCH = IF(x > 1, Measure1, Measure2)
MEASURE = CALCULATE(MEASURE SWITCH, DATEADD('Daily KPI'[ga_date],-7,DAY))
So the MEASURE will return the calculate of the measure switch that it will be Measure1 or Measure2.
I hope i'll be helpful
mark as a solution if you resolve
Ciao!
6 Replies
Hi,
1. the calculate function return the calculate of the measure in the context you specify with the filter.
So in the first one you're tell to the pbi to calculate the sum with the specify filter (date - 7 day).
2. In the second you do the calculate of the measure in the variable. And in the variable you're not specify any filter context like the data. So the sum return a value that you pass to the calculate ignoring any filter beacause you're passing a result not a measure to calculate.
If you want the sum for the previous week the correct measure is the first.
I hope I was clear.
EnjoyThanks a lot for the explanation.
So what I should put in the 2nd formula (with the variables) to make it work ? I still wish to keep the dateadd in the final variable
Thank you again
You have to do the calculate in the variable.
And then return the variable.
var sales = CALCULATE(sum('Daily KPI'[sales]),DATEADD('Daily KPI'[date],-7,DAY))
RETURN sales
Enjoy
mark as a solution if you resolve
