Distributing Total Project Task Time over Date Range Evenly

[bigmac025]

Hello,

I have a power bi question. I have project data that specifies the start and end date of the project task and the time that it is going to take between those two dates to complete the task. I would like to take the time to complete the task and spread it evenly over the days from task start date and end date. The data comes in from the API like this for example.

Project Task Name	Start Date	End Date	Total Time	Task Owner
Task 1	5/4/2025	5/10/2025	700 Minutes	Tim
Task 2	5/6/2025	5/12/2025	700 Minutes	Tim

700 minutes / 7 days = 100 minutes per day working on task 1

I need the data something like this so I can add the amount of minutes per day each person is working on project tasks in Power BI.  

Task Owner	Date	Total Time
Tim	5/4/2025	100 minutes
Tim	5/5/2025	100 minutes
Tim	5/6/2025	200 minutes
Tim	5/7/2025	200 minutes
Tim	5/8/2025	200 minutes
Tim	5/9/2025	200 minutes
Tim	5/10/2025	200 minutes
Tim	5/11/2025	100 minutes
Tim	5/12/2025	100 minutes

I can then create a visual showing how many task minutes Tim is working each day.

Doesn't have to be exactly like this, just giving an example.  There may be a better way to do this.

Any help would be apprecatied.

Thanks,

Tim

[bigmac025]

Thank you @lbendlin.  It took me a few days to validate with actual data but it works great.  I just need to use only business days in my calculation.  This is a great solution!

[v-kpoloju-msft]

Hi @bigmac025,

May i know has your issue been resolved? If the response provided by the Super user @lbendlin, addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

If yes, kindly accept the useful reply as a solution and give us Kudos. It would be appreciated.

Thank you for your understanding!

[lbendlin · Accepted solution]

here is a crude version without totals

Here's a bit more sphisticated with totals

Of course you will want to add a proper workday logic to this too to exclude weekends and holidays.