if statement custom column

[tracyhopaulson]

I have a column "Item" that I would like to find all values start with "SK" or "78", then insert a text "Do Not Use" to the custom column, otherwise, carry the values from column Item over as is.  Can someone help with this please?

[pranit828 · Accepted solution]

Hi @tracyhopaulson 

I would create  a column

_new_column = IF(LEFT([column],2) IN {"SK","78"}, "Do Not Use",[column])

[Ajinkya369]

Hi @tracyhopaulson ,

Please provide sample data.

Thank you

[tracyhopaulson]

@Ajinkya369  attaching image of data and the result I would like to achieve.  Need help with Dax formula or custom column formula please.  Thank you.

[PaulDBrown]

@tracyhopaulson

Using the CONTAINSSTRING function:

[PaulDBrown]

@tracyhopaulson 

You can create a custom column in Power Query to meet the output. The interface will allow you to choose between "contains" (to specify the string values) and the output can be custom or a column value

As an alternative, you can create a custom column using DAX in your table using the function CONTAINSTRING as the variable