Delete rows based on column values

[Anonymous]

Hello,

I have the following table loaded in Power Query and i am trying to delete specific rows:

1. If the Document ID is 4050 and Date is 01/08/2022.

2. If the Document ID is 4160 and Date is 15/07/2022.

Any help is much appreciated!

Document ID	Date	Amount
3998	04/08/2022	2439.17
4050	04/08/2022	1176.56
4050	01/08/2022	791024.45
4060	15/07/2022	11810.25
4139	20/07/2022	12352.03
4145	15/07/2022	81045.86
4149	05/07/2022	365.95
4157	05/07/2022	4509.88
4160	15/07/2022	52011
4160	06/07/2022	2922.4
4164	15/07/2022	9592.56
4166	15/07/2022	32471.67
4187	15/07/2022	6793.62
4187	15/07/2022	33938.1

[KT_Bsmart2gethe]

Hi @Anonymous ,

Add a custom step:

Table.SelectRows(PreviousStepName, each ([Document ID] <> "4050" and [Date] <> #date(2022,8,1)) or ([Document ID] <> "4160" and [Date] <> #date(2022,7,15))))

Regards

KT

[jbwtp · Accepted solution]

Hi all,

I think it may need to be something like:

each not (([Document ID] = "4050" and [Date] = #date(2022,8,1)) or ([Document ID] = "4160" and [Date] = #date(2022,7,15)))

in the condition/filter.

Kind regards,

John