topic Look if text string has substrings matching list of words in 2nd table in DAX Commands and Tips

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

Anonymous — Fri, 22 Jan 2021 15:14:11 GMT

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 — Fri, 22 Jan 2021 17:12:14 GMT

Anonymous , 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.