Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

MULTIPLE IF and OR with containstring

Dear PBI member 

i would like to create dax for below table 


logic is , 
if carrier column containstring "self" or "dff" or "" , result will "ignore" , else "handle"

Thanks 
SE 

  • Anonymous , a new column

     

    if(isblank([carrier]) || [carrier] in {"", "self", "dff"} , "ignore" , "handle")

2 Replies

  • Anonymous , a new column

     

    if(isblank([carrier]) || [carrier] in {"", "self", "dff"} , "ignore" , "handle")