By this time, you already know how to count the number of words in Power Query. This was covered here – Power Query – Tips & Tricks 1 – How to Count Number of Words. Here comes Power Query Challenge 1.
The count of words in each row is needed. The challenge is that the solution has to be completely UI (user interface) driven. After loading the table in PQ, you should not press even a single key to come up with the result. You should use only mouse.
Of course, the query should be dynamic i.e. even if number of words increase or decrease in a line OR/AND number of rows increase or decrease, the Query should give right result on Refresh.
The file for this challenge can be downloaded from – PQ_Challenge_1_Problem
The solution to Power Query Challenge 1 will be published after a week i.e. on Monday, 11-Oct-21.
Solution link – Solutions to Power Query Challenges – 1 to 7
Power Query M function reference – PowerQuery M | Microsoft Docs