Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
Solved! Go to 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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.