Forum Discussion

Elliot137's avatar
Elliot137
Regular Visitor
3 years ago
Solved

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

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.

Need Help
  • BA_Pete's avatar
    BA_Pete
    3 years ago

    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

3 Replies

  • BA_Pete's avatar
    BA_Pete
    Super User
    3 years ago

    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

    • BA_Pete's avatar
      BA_Pete
      Super User
      3 years ago

       

      No problem.

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

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

       

      Pete