Filter Power Query row based on 2 column values

[MarioCadena]

Hi,

I have been trying to filter out rows that contain 2 specific values from one column each. I try to use the filter option with and as per the below formula

= Table.SelectRows(#"Removed Columns1", each ([Order Number] <> "PC112936" and [Invoice Date] = #date(2020, 4, 14)))

but instead of deleting rows when both values appear; power query is deleting them individually; so delete any [Order Number] <> "PC112936" or [Invoice Date] = #date(2020, 4, 14)

Could please provide some help?

[Vera_33 · Accepted solution]

Hi @MarioCadena 

If I understand it correctly, you are trying to remove rows containing [Order Number] = "PC112936" and [Invoice Date] = #date(2020, 4, 14), select the rest rows, have a try:

= Table.SelectRows(#"Removed Columns1", each [ a =[Order Number] = "PC112936" and [Invoice Date] = #date(2020, 4, 14), b = a = false][b])

[PhilipTreacy]

Hi @MarioCadena 

Just create 2 separate filter steps?

Regards

Phil