Forum Discussion
Anonymous
2 years agoNot applicable
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
- AhmedxSuper User
Can you please share your demo input and expected output!
- AnonymousNot 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?
- AhmedxSuper User
pls see my video