Forum Discussion
DAX CALCULATE expression error
The error you're encountering is because you are using double quotes ('') to enclose the year '2019' within your DAX expression, which is causing a syntax error. In DAX, you should use single quotes (') to enclose text values. Here's the corrected expression:
=CALCULATE([Net_sales], dim_date[FY] = "2019")
In this corrected expression, '2019' is enclosed in double quotes, which is the correct way to specify a text value in DAX. Make sure your column [FY] in the dim_date table also contains '2019' as a text value for this expression to work correctly.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
In case there is still a problem, please feel free and explain your issue in detail, It will be my pleasure to assist you in any way I can.
The error you're encountering is because you are using double quotes ('') to enclose the year '2019' within your DAX expression, which is causing a syntax error. In DAX, you should use single quotes (') to enclose text values. Here's the corrected expression:
=CALCULATE([Net_sales], dim_date[FY] = "2019")
In this corrected expression, '2019' is enclosed in double quotes, which is the correct way to specify a text value in DAX. Make sure your column [FY] in the dim_date table also contains '2019' as a text value for this expression to work correctly.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
In case there is still a problem, please feel free and explain your issue in detail, It will be my pleasure to assist you in any way I can.
Thank you for the detailed answer and solution. It is working with this solution now. I got it fixed earlier with the help of ChatGPT, I copied the DAX syntax from there and it was the same syntax that I had written, and then pasted it in pivot measure and it worked.
However, then I deleted the measure and created it again, and again it was returning error despite the rught syntax, I again copied the syntax from ChatGPT and it worked. Don't know why it accepts the same copied DAX syntax from ChatGPT and returns the value and when I enter the DAX syntax while creating measure it returns error and shows red line under 2019 after entering single or double quotes.
