Forum Discussion

anupambit1797's avatar
anupambit1797
Iron Contributor
May 09, 2025

Power Query Question

Dear Experts,                       Greetings! I have a data like below In column A, we have different Organizations, and in B, I want like if A contains "L3 SW" or "CP Integration", then put ...
BI & Data Analysis
excel
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
May 09, 2025

That's in formula bar or in Advanced editor. Start conditional column in interface, next modify the code in editor, something like

...
    AddColumn = Table.AddColumn( PrevStep, "Custom",
        each
           if Text.Contains([Reporter Team], "VRF") then "VRF" else
           if Text.Contains([Reporter Team], "L3 SW") or Text.Contains([Reporter Team], "CP Integration") then "L3 SW" else
           if Text.Contains([Reporter Team], "CNS") then "CNS" else
           "nothing", type text),
    NextStep = ...

Resources