Forum Discussion

Sascha_17's avatar
Sascha_17
Frequent Visitor
9 years ago
Solved

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 ?

  • Sascha_17's avatar
    Sascha_17
    9 years ago

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

3 Replies

  • Sascha_17's avatar
    Sascha_17
    Frequent Visitor
    9 years ago

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

  • dkay84_PowerBI's avatar
    dkay84_PowerBI
    Microsoft Employee
    9 years ago

    Is column 1 set to numeric data type?

     

    Also what is your regional setting?

  • v-haibl-msft's avatar
    v-haibl-msft
    Microsoft Employee
    9 years ago

    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