Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Doing a search against multiple strings

Hi,   The below should be relatively easy to fix in DAX but somehow I do not succeed.   For simplicity sake here is a dummy fact table:   ID Content Required Column 1 Text1,te...
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , A new column like

     

    Switch( True() ,
    containsstring([Content],"text2") && containsstring([Content],"text2") , "2plus4",
    containsstring([Content],"text1") && containsstring([Content],"text5") , "1plus5",
    containsstring([Content],"text2"), "text2",
    "Other")

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

Anonymous , A new column like

 

Switch( True() ,
containsstring([Content],"text2") && containsstring([Content],"text2") , "2plus4",
containsstring([Content],"text1") && containsstring([Content],"text5") , "1plus5",
containsstring([Content],"text2"), "text2",
"Other")