DAX Syntax Error

[Sascha_17]

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 ?

[Sascha_17 · Accepted 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...

[v-haibl-msft]

@Sascha_17

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

[dkay84_PowerBI]

Is column 1 set to numeric data type?

Also what is your regional setting?