How to measure cumulative active project hours from start and end dates?

[gzimmer]

I have a table of active projects, each with their name, ID, start date, end date, and assigned hours per day. I want to create a graph looking ahead 6+ months of all the hours we are expecting these projects to take up. Right now, I'm building a table starting with a column of every working day from the beginning of 2021 to mid 2022. I'd like to take each of these dates, and go through the whole table of active projects looking for all projects that have start dates before or on the work date and end dates after on on the work date, then sum all of the expected hours per day of these projects. How can I accomplish this?

[colacan]

@gzimmer  Hi, gzimmer, if you provide a sample data along with the output expected, it will be very helpful to understand your issue.

[amitchandak]

@gzimmer ,  refer if my HR blog can help

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

seems like  similar topic