Help with Custom Column Formula

[mukagalvani]

Hey there!

I'm trying to create a custom column using nested ifs, but i'm having a syntax error.

The idea is simple. I think some parenthesis are missing.

Thanks for the help!

[Greg_Deckler · Accepted solution]

Looks like you are mixing DAX and M syntax. 

M syntax should look like this:

=if [Nota] <=6 then "Detrator" else if [Nota]>6 and [Nota]<=8 then "Neutro" else if [Nota]>8 then "Promotor" else "error"

DAX would look like:

Column = IF([Nota]<=6,"Detrator",IF([Nota]>6 && [Nota]<=8,"Neutro","Promotor"))

[mukagalvani]

Greg,

Thanks a lot!

I'll try your solution asap, but it looks correctly, I actually mixed both languages.