Forum Discussion
Power Query Conditional Column
Dear Experts,
Greetings!
How can I use multiple-IF with "OR" condition in PQ?So if Column1 has any of the mentioned strings populate the next Column.
Thanks in Advance,
Anupam
Please carefully look at my 1st post. It says/shows "Custom Column", you do "Conditional Column". I suspect this is the reason of your last issue
5 Replies
No idea what you're doing so this might not be the best approach... You can do it this way:
Thanks Lorenzo I tried this;
= if Text.Contains([Column1], "0xB821") or
Text.Contains([Column1], "Physical Cell ID") or
Text.Contains([Column1], "Freq") or
Text.Contains([Column1], "inOneGroup") or
Text.Contains([Column1], "groupPresence") or
Text.Contains([Column1], "ssb-ToMeasure") or
then [Column1] else nullIt says:-
Thanks & Regards
Anupam Shrivastava
You have an extra or before then. Fix:
= if Text.Contains([Column1], "0xB821") or Text.Contains([Column1], "Physical Cell ID") or Text.Contains([Column1], "Freq") or Text.Contains([Column1], "inOneGroup") or Text.Contains([Column1], "groupPresence") or Text.Contains([Column1], "ssb-ToMeasure") then [Column1] else null
