Look if text string has substrings matching list of words in 2nd table

[daaf_ratsma]

Hello,

i have table 1 with text strings (product descriptions) and i want to see if that text string contains 1 or more words listed in table 2.

Any one how to do this ?

[amitchandak]

@daaf_ratsma , A new column in table 1 like

countx(filter(search(Table2[column], Table1[column],,0)>0), Table2[column])

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.