Forum Discussion

arneshabobo's avatar
arneshabobo
New Member
4 years ago
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...
Need Help
  • smpa01's avatar
    smpa01
    4 years ago

    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)

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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's avatar
arneshabobo
New Member
4 years ago

Thanks so much for replying!