Community

Forum menu

[Closed] Power Query query

mrsheen

Posts: 1110

Free Member

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 9:43 pm

rogermoore

Posts: 1144

Full Member

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 10:32 pm

mrsheen

Posts: 1110

Free Member

Topic starter

@rogermoore thank you sir that's incredibly helpful of you 👍👍👍👍👍

Posted : 28/02/2022 2:11 am