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.

Anonymous's avatar
Anonymous
Not applicable
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.