Forum Discussion
Solved
New Measure Error for Current Year Sales
Hi everyone. I'm working on a new measure for current year sales. I received the following error: The syntax for 'RETURN' is incorrect. (DAX(Var CY = MAX('Date Dim'[Year]RETURNCALCULATE(SUM...
arneshabobo try this, You missed the closing Parenthesis in VAR CY
CY Sales =
Var CY = MAX('Date Dim'[Year])
RETURN
CALCULATE(SUM(Actuals[Sales Amount]),'Date Dim'[Year]=CY)
smpa01
Community Champion
Community Championarneshabobo edited again, try now.
That worked! Thanks so much for your swift response.