Forum Discussion
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 ...
pls see my video
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?
pls see my video