Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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?
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |