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

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

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.