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
BA_Pete
Super User
Super UserHi Alicia_Anderson ,
Try this:
if Text.Contains([Release1], "ABC")
or Text.Contains([Release2], "ABC")
or Text.Contains([Release3], "ABC")
then "Y"
else "N"
Pete
Alicia_AndersonResolver I
Resolver IThat is what I have. Any row that has a null in one of those fields produces an Error.
- Alicia_Anderson
If 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
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