Power Query Filter - Exclude all rows where a value matches

Question

Hi! We have a database of systems linked to specific location numbers, referred to as site numbers. There can be multiple system numbers linked to one site number. Each system has its own installation date and activation date, and the dates can all be different as well. However, the system numbers are all unique, even between different sites.

As an example:

Site 1000 has system numbers 1, 2, 3 and 4.
System numbers 1 and 2 were activated and installed 1/1/2022
System number 3 was installed 1/1/2022 but activated 3/1/2022
System number 4 was activated and installed 3/1/2022

What I need to do is filter the query for any systems that were activated within the last week, which is not a problem. However, I need it to exclude any other systems that have the same site number from that filter. In the example above, if the current date were 3/2/2022, if the filter worked it would still show all 4 of the systems that are under site 1000, even though only 2 of them were activated recently.

I guess the basic question is: how could I update the query to make sure that if any of the systems with that site number test as "true", it will exclude all of them from the filter?

Any advice is greatly appreciated. I've been trying to work something out on my own, but have been unable to come up with a solution.

Answer 1

Power query is not currently supported here on Q&A. The product group for Power Query actively monitors questions over at
https://community.powerbi.com/t5/Power-Query/bd-p/power-bi-services

--please don't forget to Accept as answer if the reply is helpful--