Solved: Re: Help with Custom Column Formula

mukagalvani · ‎01-24-2019

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 · ‎01-24-2019

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"))

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Greg_Deckler · ‎01-24-2019

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"))

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

mukagalvani · ‎01-24-2019

Greg,

Thanks a lot!

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

Help with Custom Column Formula