Word Count

[maurcollins]

Good Morning

Is there a way to complete a word count in a sentance in power bi. There is no specific icon separating the words it can vary as it is a free text field being evaluated so just need a basic word count. The aim will then be to say if less than for example 100 characters this is poor etc..

Preferably using DAX

Example:
the cow jumped over the moon - would return a count of 6.

Thank you

[AbbasG]

@maurcollins not sure about the dax, but it can be done through power query.

You can refer to the following video - https://www.youtube.com/watch?v=Btl7fecv1RQ

I was able get your desired output, hope it helps.

[Pragati11]

HI @maurcollins ,

Check this existing thread on the forum. This might help.

https://community.powerbi.com/t5/Desktop/How-to-count-number-of-words-in-a-column-and-not-character/...

[Surya9]

Check this post 
https://community.powerbi.com/t5/DAX-Commands-and-Tips/How-to-count-the-number-of-words-in-a-table/m...