Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Dear all
I have a DAX Syntax problem in PowerBI Desktop. I have following formula 'IF(Column1 > 5, "hh", "hh")'. PowerBI sends me an error message that the syntax is not right. Strangely in the error message, powerbi replaced my comma after 5 with a point.
Please see picture below:
Anybody knows whats the problem here is ?
Solved! Go to Solution.
Thanks for your answers.
I found the answer / workaround by myself. I have to add a space before the comma, then PowerBI accept my DAX Syntax...
Thanks for your answers.
I found the answer / workaround by myself. I have to add a space before the comma, then PowerBI accept my DAX Syntax...
How about the result if you copy the second comma, paste and replace the first comma in your DAX syntax?
If issue still persists, could you please upload your PBIX file to some file hosting services like OneDrive, and then share to me?
Best Regards,
Herbert
Is column 1 set to numeric data type?
Also what is your regional setting?