Forum Discussion

Bansi008's avatar
Bansi008
Icon for Helper III rankHelper 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.

anmolmalviya05's avatar
anmolmalviya05
Icon for Super User rankSuper User
2 years ago

Hi Bansi008, Hope you are doing good !

To create a custom column in Power BI's Power Query Editor that checks if the sec_name column contains the string "ABC Corp 1" and then populates "ABC" if true, or "NA" otherwise, you can use the following syntax in M language:

  1. Open Power Query Editor.
  2. Go to "Add Column" and select "Custom Column."
  3. Use the following formula: if Text.Contains([sec_name], "ABC Corp 1") then "ABC" else "NA"
  4. Click OK

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!