Forum Discussion
Powerquery > Advanced Filter not working with multiple clauses
I have a large list of product data from Amazon (5000 rows) and need to remove irrelevant products based on text that shows in the product title column. So I have used powerquery and the Advanced Fi...
=Table.SelectRows(#"Trimmed Text", each not List.Contains({"Word 1","Word 2","Word 3"},[Title],(x,y)=>Text.Contains(y,x)))
=Table.SelectRows(#"Trimmed Text", each not List.Contains({"Word 1","Word 2","Word 3"},[Title],(x,y)=>Text.Contains(y,x)))