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 ...
Need Help
Ahmedx's avatar
Ahmedx
Super User
2 years ago

Can you please share your demo input and expected output!

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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?