Forum Discussion

Bansi008's avatar
Bansi008
Helper III
2 years ago
Solved

Need help in conditional statement.

Hi there, In new custom column i wanted to write syntax as if column [sec_name] contains ABC corp 1 then populate ABC else NA.  can someone please help me with syntax which will work in PowerBI tra...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.