Count the number of times unique words in a column...

eriksri · ‎02-13-2018

I have two tables.

Table1 which has a column with sentences, Sentences

Table2 which has a column with unique words, UniqueWords.

I want to know for each word in UniqueWords in Table2, how many times they occur in the column Sentences in Table1.

Greg_Deckler · ‎02-13-2018

See my quick measure subscription here:

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Count the number of times unique words in a column occur in a text column in a non related table