topic How to measure cumulative active project hours from start and end dates? in DAX Commands and Tips

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

Anonymous — Tue, 05 Oct 2021 16:30:45 GMT

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?

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

amitchandak — Wed, 06 Oct 2021 09:10:28 GMT

Anonymous , refer if my HR blog can help

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970

seems like similar topic

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

colacan — Wed, 06 Oct 2021 18:38:41 GMT

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