Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

DAX showing error

I am trying to write a dax statement but it says syntax for status is incorrect. The DAX is :

 

MTD = CALCULATE(SUM(C[T_C]),MONTH('Date'[DATE]) = MONTH(TODAY()), YEAR('Date'[DATE] = YEAR(TODAY()),STATUS = "C" || STATUS = "V" || STATUS = "D" || STATUS = "C")

 

The italic and underline part is showing the red line. 

Need Help
  • lbendlin's avatar
    lbendlin
    4 years ago
    MTD = CALCULATE(SUM(C[T_C])
                ,MONTH('Date'[DATE]) = MONTH(TODAY())
                ,YEAR('Date'[DATE]) = YEAR(TODAY())
                ,STATUS IN { "C","V","D"}
)

    You missed a closing parentheses after YEAR().

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago
    MTD = CALCULATE(SUM(C[T_C])
                ,MONTH('Date'[DATE]) = MONTH(TODAY())
                ,YEAR('Date'[DATE]) = YEAR(TODAY())
                ,STATUS IN { "C","V","D"}
)

    You missed a closing parentheses after YEAR().