Forum Discussion
Alicia_Anderson
Resolver I
Resolver IHelp 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 ...
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
Alicia_AndersonResolver I
Resolver IIf I change the nulls to "" beforehand, it works without a problem. Not sure what problems or concerns there may be with doing that.
BA_Pete
Super User
Super UserHi 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