Need help in conditional statement.

Hi Bansi008 ,

Thank you for anmolmalviya05 and daircom answer , and I have other suggestions for you:

Below is my table:

I try this expression:

= Table.AddColumn(#"Changed Type", "Custom", each if Text.Contains([sec_name], "ABC corp 1") then "ABC" else "NA")

The final output is shown in the following figure:

If this doesn't work, please provide a screenshot of the error

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.