 You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
Topic starter
I have thousands of rows of words ranging from single words up to the teens in number used per row. Raw data is in excel/csv then loaded via power query to power BI.
Is there a way to filter out those rows which contain fewer than three words?
Thanks
Posted : 27/02/2022 8:43 pm
Assuming your words are separated by spaces, you can add a custom column in PQ as follows: List.Count(Text.SplitAny([Column1]," "))
Then filter that column to be greater than 2.
RM.
Posted : 27/02/2022 9:32 pm
Topic starter
@rogermoore thank you sir that's incredibly helpful of you 👍👍👍👍👍
Posted : 28/02/2022 1:11 am