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 thou...
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

Elliot137's avatar
Elliot137
Regular Visitor
3 years ago

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

  • 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