how to slpit a duration to serval dates

[RobinH]

Hi Community

I hope i'm the right sub.

I have a task with let's say 50 Minutes duration.

The Task have a startdate (06 July 2020) and an enddate (10 July 2020).

Is there a possibily to devide the duration with the days, so that i get 10 minutes per day on monday, 12 minutes per day on tuesday etc.

My Goal ist to see the workload over a time.

Thanks and regards

Robin

[RobinH]

Good evening

Still would appreciate some help, haven't figure out a solution.

I try to get these 12136 hours splited to the remainig time (today or if later startdate and the end date 2020/12/31).

Thank you Community

Robin

[amitchandak]

@RobinH , refer if this file can help. Similar Solution

https://www.dropbox.com/s/yuv64v0cneseghx/value%20Split%20between%20months%20start%20end%20date.pbix...

[harshnathani]

Hi @RobinH ,

See if this solution helps.

https://community.powerbi.com/t5/Desktop/Splitting-hours-between-working-days/td-p/684521

Regards,

Harsh Nathani

[RobinH]

Hi @harshnathani 

Sorry for the late Feedback.

In this solution the start date is fix if i see correctly, what happen if the startdate is in the past? In my case it should stack the time to the remaining days between the actual date and the end date (if the start date is in the past).

regards