Forum Discussion
Finding matching substring with DAX
I have two tables "Sentences" and "Words". My goal is to add a calculated column/measure to the "Sentences" table, which contains the words that also occur in the Words table. The "Sentenc...
Hi,
From the 1 column Words table, build a 3 column table with the original, English and Spanish columns. Modify my calculated column formula to:
Words found = CONCATENATEX(FILTER(VALUES(words[Words]),CONTAINSSTRING(sentences[text],words[English])),words[Words],",")Hope this helps.
I have tried it, but unfortuanatelly received this error message:
Is there a different solution?
Looking at the accepted solution, your proposed of two tables in to one was meant as an addition on the first. I thought you wanted a third table.
If you would put what I wrote into a new custom table, it should work.