Counting words in text string

Hi Frederic,

Thank you for the forum question.

I do not know, if you have watch the video (link below).

She is doing a word count in Power Query.


https://www.youtube.com/watch?time_continue=154& ;v=Btl7fecv1RQ&feature=emb_logo


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Hi Frederic,

My name is Ron. I am one of STL's trainers. You will have probably resolved the word count issue already but it was not marked as resolved in our forum yet so I attached a Word document with a possible solution just to make sure.
The reason you say the functions are not available in your Power Bi is that these functions are only available in Power Query and not if you use the 'New Column' tool in Power Bi Desktop.
Please have a look at the attached Word document that Jens and I put together. If you cannot locate the attachment, just reply with your email address and I will send it to you via Email

If it works for you or if you already found a fix could I please ask you kindly to mark the question as resolved in our forum.

Please keep safe and well

Kind regards

Ron Oldeboom
Learning and Development Consultant
STL-Training