Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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

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!!

3 Replies

  • Can you please share your demo input and expected output!

    • Anonymous's avatar
      Anonymous
      Not applicable

      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?