Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I am trying to write a dax statement but it says syntax for status is incorrect. The DAX is :
The italic and underline part is showing the red line.
Solved! Go to Solution.
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().
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().
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 64 | |
| 55 | |
| 27 | |
| 18 | |
| 18 |