Forum Discussion
Solved
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, A...
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
Thanks Lorenzo ,
after using the one you mentioned(deleting the extra "or"), getting "Expression Error":-
= 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
Br,
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