Power Query M: Filter rows between two dates and another condition

[Anonymous]

Hello!

I need to append two querys that have overlapping data in a few occurences. 

Luckily I know, where those overlapps are. 

I therefore need a formular that filters conditions in two rows at the same time. 

Something like: 

filter rows if the date in colum date is before 30.06.2022 and the company in column company is X

Thanks!!

[Ahmedx]

Can you please share your demo input and expected output!

[Anonymous]

Condition: Filter out rows where date is before 30.06.2022 and company = X

So only the two colums with red text should be filtered.

Date		Company
01.01.2022		X
01.01.2022		X
01.01.2022		Z
01.01.2022		Z
31.12.2022		X
31.12.2022		X
31.12.2022		Z
31.12.2022		Z

Does this somehow makes sence?

[Ahmedx · Accepted solution]

pls see my video

https://1drv.ms/v/s!AiUZ0Ws7G26RixMIdeBuSzB2J4Z7?e=q72Dei