FIltering Project Count by Create Date and End Date

[jjmanx]

Hey all, I hope you can help.

I have 2 visuals, 1 showing a count of projects using a create date, the second showing a count of projects using the end date.

When I select a month on the create date visual it isolates all the projects which have an end date within that same period on the second visual.

What I actually need is when I select a month in the create date visual, I want to see when all of those projects are are due to end. 

i.e. when I select Jan 2022 as the create month, I should see a count of how many of those projects are due to end in June, July, Aug, etc, etc in the second visual.

I'm sure it's something straightforward but I'm at a dead end! Thank you! 🙂

[amitchandak]

@jjmanx , I think this can help

Power BI HR Active Employee Tenure Bucketing, and Hired, Terminated, and Active employees: https://youtu.be/fvgcx8QLqZU

Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...