Forum Discussion

GSmithDesign's avatar
GSmithDesign
Frequent Visitor
4 years ago
Solved

Find Top N terms in a text string

I want to see how often the most common words are used in a list of movie titles. Sample PBIX I split, grouped, and counted the words in the titles in Power Query. I created a measure to find the T...
  • GSmithDesign's avatar
    4 years ago

    Just to follow up, someone on the EnterpriseDNA forum was able to work out how to do this. From his solution, I realized that I sometimes need to search on phrases, which made it more complicated. The back and forth with explanations is in that thread, and here's the subsequent pbix solution.