Can't figure how to approach this one so think I need some fresh eyes.
If you see in attached example. I have a list of projects with Start & Finish dates.
I want to be able to filter the projects for a specific Year and Qtr - but the twist is I want to see all projects ACTIVE during that Qtr.
So, say a project started on 15/12/2021 and finished on 30/06/2022 - that project was active in Q4 2021, Q1 2022, and Q2 2022. So if I filter for any of those QTRs, that project should appear.
Ideally I'd like to achieve this through Power Query but any ideas would be appreciated.
Bookmarks