Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The 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.

Reply
Sascha_17
Frequent Visitor

DAX Syntax Error

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:

 

PowerBI Bug

 

Anybody knows whats the problem here is ?

1 ACCEPTED SOLUTION
Sascha_17
Frequent Visitor

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...

View solution in original post

3 REPLIES 3
Sascha_17
Frequent Visitor

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
Microsoft Employee
Microsoft Employee

@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
Microsoft Employee
Microsoft Employee

Is column 1 set to numeric data type?

 

Also what is your regional setting?

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!