IF FORMULA HELP

[erhan_79]

hi there ;

i need your supoort about below formula ;

i have tableA which include below vendor volumn

İ would like to create a new column and it must list like that ;

IF vendor includes " ABC" write this cell  " Important" , If vendor includes "DEF" write this cell  " Not Important" ; If none of them cell will be empty 

thanks in advance for your kind supports 

[amitchandak · Accepted solution]

@erhan_79 ,

Create a new column like

Switch( true(),
search( "ABC" ,[column],,0)>0,"Important",
search( "DEF" ,[column],,0)>0,"Not Important",
"Not Important"
)

Or a if like this

if(search( "ABC" ,[column],,0)>0,"Important",if(search( "DEF" ,[column],,0)>0,"Not Important",blank()))

You can also use containsstring

https://docs.microsoft.com/en-us/dax/containsstring-function-dax