Forum Discussion

Alicia_Anderson's avatar
Alicia_Anderson
Resolver I
4 years ago
Solved

Help with Power Query custom column with multiple conditions and Text.Contains

I am trying to create a Custom Column in Power Query that looks for a text string in any of three different text fields.  My main issue is that any of the fields may contain a null value and this is ...
Need Help
  • BA_Pete's avatar
    BA_Pete
    4 years ago

    Hi Alicia_Anderson ,

     

    Try this instead:

    try
if Text.Contains([Release1], "ABC")
    or Text.Contains([Release2], "ABC")
    or Text.Contains([Release3], "ABC")
then "Y"
else "N"
otherwise "N"

     

    This gives the following output:

     

    Pete