How to build column of cumulative active project hours?

[gzimmer]

I have a table of active projects, with their name, ID, start date, end date, and expected hours per month. 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 end of month date from the beginning of 2021 to mid 2022. I'd like to take each of these EOMdates, and go through the whole table of active projects looking for all projects that have start dates before or on the EOMdate and end dates after on on the EOMdate, then sum all of the expected hours per month of these projects. How can I accomplish this?

[BA_Pete]

Hi @gzimmer ,

This really sounds like a DAX thing. You've posted this on the Power Query board so I can move your post to the Desktop board if you want?

If you really need this done in Power Query for some reason, then can you post a copyable example of your active projects data please?

Pete