topic Re: Doing a search against multiple strings in DAX Commands and Tips

Doing a search against multiple strings

Anonymous — Wed, 27 Apr 2022 13:03:53 GMT

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,text2text3,text4,text5	2plus4
2	Text1	other
3	Text2,Text4	2plus4
4	Text1,text5	1pus5
5	Text1,Text4,Text5	1plus5
6	Text0Text2text99	Text2
7	Text 18	Other

I try to get a new (calculated) column that checks in the following order:

Is “text2” and “text4” part of the content column? If so the new column should show “2plus4”
Is “text1” and “text5” part of the content column? If so the new column should show “1plus5”
Is there another column that contains “text2? If so the new column should “Text2”
In all other cases the new column should show “Other”

Your help is appreciated,

(Worst)Kees

Re: Doing a search against multiple strings

amitchandak — Wed, 27 Apr 2022 16:26:31 GMT

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")

Re: Doing a search against multiple strings

Anonymous — Wed, 27 Apr 2022 19:50:40 GMT

amitchandak thanks, this is brilliant.

Do you have any idea why "?" or "/?" is not working for my "text2" while if I use any other combination of characters, it works? No big deal (I created a workaround) but just curious.

Kind regatds & thanks again,
(Worst)Kees