Power Query filter logic help

[lrobb]

Hello All,

I am looking to setup some filter logic in power query. I can do this in SQL but for some reason I can't get it to evaluate right in PQ (M). What I'm looking for is this:

Include everything except when the qty is greater than 1 AND the address number is a specific address. In SQL I would do it like this:

WHERE

Existing filter conditions
AND NOT (address=123456 AND qty >1)

Is there an equivalent of "AND NOT" in PQ?

TIA!

[CNENFRNL]

Since sql works well, why bother to code M queries? Use PQ to connect your database and import the result in one shot.