When I calculate this single expression it is ok:
But when I wrap it inside a variable, I get the error "The syntax for LastActualDate is incorrect"
Am I doing something wrong? (Excel2013 Powerpivot)
CALCULATE(SUM(AppendOGOAll[P2017cost]),FILTER(ALL(CalendarTable[Calendar Date]),CalendarTable[Calendar Date] <= LastActualDate))
Go to Solution.
1. DAX variables are only available from the 2015 edition of DAX so: PowerPivot for Excel 2016, Power BI Desktop & SSAS 2016. Thus, not in PowerPivot for Excel 2013.
2. In any of the three softwares mentioned above, you should remove the " : " in the variable definition and also remove the 'filter' function (which is useless thanks to the variable).
This one would work:
BudgetYTD = VAR LastActualDate=LASTNONBLANK(Clasa6si7[FECHA],1) RETURN
Calculate( SUM(AppendOGOAll[P2017cost]) , CalendarTable[Calendar Date] <= LastActualDate)
View solution in original post
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.