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 
Need Help
Show and Tell
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , a new column

     

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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , a new column

 

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