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.
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.
Thank you Ashish_Mathur 🙂
After the VALUES function I had to pass the "Words" table and not the "Words[WORDS]" collumn.
You are welcome.