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)
Hi! Thank you for responding. I added the parenthesis but now the error says " too many arguments were passed to the SUM function. The maximum argument count for the function is 1."
smpa01
Community Champion
Community Championarneshabobo edited again, try now.
That worked! Thanks so much for your swift response.