Using 'IF' and 'Text.End' in the same function

[Elliot137]

I have a column called Block Number in my table in which every imput ends with a letter. I want to create a new column which auto fills with yes or no depending on the letter?

This is what I thought it should look like but its coming up with a missing right parenthesis error?

=if(Text.End([Block Number],1)="T","YES",if(Text.End([Block Number],1)="V","YES",if(Text.End([Block Number],1)="W","YES", "NO")))

Any Help would be appreciated.

[Elliot137]

Thanks a lot @BA_Pete didn't realise if was a DAX function. Worked perfectly.

[BA_Pete]

No problem.

IF( thisThing, thenThatThing, elseOtherThing ) is DAX/Excel syntax.

if thisThing then thatThing else otherThing is M code/Power Query syntax.

Pete

[BA_Pete · Accepted solution]

Hi @Elliot137 ,

You're using DAX IF syntax with M code functions.

In Power Query you could do something like this:

if List.Contains({"T", "V", "W"}, Text.End([Block Number], 1)) then "YES"
else "NO"

Pete