Power Query Editor Complex Filter

[Sayri]

Hi,

Would it be possible to do complex filtering in the Power Query Editor ?

Here is my case:
To reduce the number of loaded rows to create my table, I'd need to do something like:

(Filter 1 AND filter 2 AND filter 5 AND filter 6) OR (Filter 3 AND Filter 4)

where Filter 1,2,3,4,5,6 are basic filters like:

 Table.SelectRows(Table1, each ([ColumnA] <> null and [ColumnA] <> "Sample Name" and [ColumnA] <> "Sample Name x"))

Thanks

[stvsurf · Accepted solution]

you can copy the filter code and combine it all in 1 in your formula bar

e.g. = Table.SelectRows(#"Changed Type", each ([ColumnA] = "a" and [ColumnB] = "b") or ([ColumnA] = "c" and [ColumnB] = "d"))