Forum Discussion
Word Count
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
3 Replies
HI Anonymous ,
Check this existing thread on the forum. This might help.
Anonymous 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.
