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 transform view.

I tried :- IF [sec_name] contains "ABC Corp 1" then "ABC" else "NA"

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.

5 Replies

  • 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.

  • daircom's avatar
    daircom
    Resolver II
    2 years ago

    Hi Bansi008 ,

     

    You need the functon Text.Contains (watch out, it is case sensitive).
    So:

     

    if Text.Contains([sec_name], "ABC Corp 1") then "ABC" else "NA"

  • anmolmalviya05's avatar
    anmolmalviya05
    Super 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 !!