New Measure Error for Current Year Sales

[arneshabobo]

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(Actuals[Sales Amount],'Date Dim'[Year]=CY))).

Here is my formula:

Line 1 CY Sales = 

Line 2 Var CY = MAX('Date Dim'[Year]

Line 3

Line 4 RETURN

Line 5 CALCULATE(SUM(Actuals[Sales Amount],'Date Dim'[Year]=CY)

Line 6

I'm not sure why I received this error message. 

[smpa01 · Accepted solution]

@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)

[arneshabobo]

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."

[Anonymous]

HI @arneshabobo 

 You missed the closing paranthesis for the SUM function too, pls close it, it should work.

CALCULATE(SUM(Actuals[Sales Amount]) ,'Date Dim'[Year]=CY)

Thanks
Raj

[arneshabobo]

Thanks so much for replying!

[smpa01]

@arneshabobo  edited again, try now.

[arneshabobo]

That worked! Thanks so much for your swift response.