DAX IF Statement not working anymore

[Anonymous]

Hi!

It's the strangest thing. I'm trying to calculate NPS score and have used this IF statment for classifying the values between 0 - 10.

Classses = IF([NPS]<=6, "Detractors", IF([NPS]<=8,"Neutrals","Promoters"))

This syntax has worked for me before but now when I open the report it gives me an error:

"The syntax for '"Detractors"' is incorrect. (DAX(IF([NPS]<=6. "Detractors", IF([NPS]<=8."Neutrals","Promoters"))))."

Can anyone please help me with this?

[TomMartens · Accepted solution]

Hey,

I guess this is due to some "quirkiness", please try to rewrite this line

Classses = IF([NPS]<=6, "Detractors", IF([NPS]<=8,"Neutrals","Promoters"))

like so

Classses = IF([NPS]<=6 , "Detractors", IF([NPS]<=8 ,"Neutrals","Promoters"))

There is just this difference, I added a space between the numbers and the comma.

There seem to be circumstances / combinations that will lead to a replacement of a comme to a point, as the parser treats the comma as a decimal separator. 

Regards,
Tom

[Vikram123]

Please Find your NPS Column TYPE is whole number or not 

[Anonymous]

It is a whole number.

Seems that this has something to do with localization settings. As you saw, I had the formula with commas ",". However, when my collegue downloaded the report from powerbi.com, the formula worked and was written in semicolon ";". I still can't get the formula to work with comma nor semicolon. When I download the report from powerbi.com it seems that the language is in Finnish so the syntax should be written with semicolons. However when I look at the formula it is written with commas and gives me the error. My collegue didn't have the error message and everything was working ok.