Forum Discussion
Solved
Counting words in a column
A table contains a column with 7188 rows. Each row contains a short phrase or a single word. I want to go through row by row and see how many times a phrase appeared. Like how many times did "house c...
If you use the key phrase column as your row headers in a matrix and create the below measure
Key Phrase Count =CALCULATE( COUNTROWS( PhraseTable))Put the measure in your matrix and that should be good.
I don't know if it is possible also in DAX, but using only a function in PQ,
starting from this data table
you can get this result:
Hi Anne,
will you only see a distinct phrase in each row or can you have multiple instances of different phrases in one row?
In this case, each row will only have one phrase. It might be a few words or sometimes just one word: "shipping." 7,188 rows, some with commonly-used phrases, some with one-off phrases, some with one single word. I need to identify the phrases customers mention most.
Thank you
Anne