Weekly Workload Calculation

[venkatramp]

Hi,

I am trying to calculate weekly workload for the team.

Eg: When a developer plans to complete a Task in 3 weeks (07/06/2020 to 07/24/2020) then his work load should be distributed to 3 weeks (i.e. 60/3 = 20 hours/Week), so he has 20 hours of work for next three weeks.

Raw Data

Name	Work Load	Start Date	End Date	Scheduled Hours
James	Build	7/6/2020	7/24/2020	60
James	Planning	7/13/2020	7/24/2020	60
James	Planning	7/13/2020	7/17/2020	30
James	Bugs	7/20/2020	7/24/2020	30
James	Development	7/27/2020	7/31/2020	20
Peter	Planning	7/6/2020	7/10/2020	50
Peter	Testing	7/13/2020	7/31/2020	90
Peter	Bugs	7/20/2020	7/24/2020	10
Henry	Planning	7/6/2020	7/10/2020	20
Henry	Analyze	7/13/2020	7/17/2020	40
Henry	Bugs	7/20/2020	7/24/2020	40
Henry	Testing	7/6/2020	7/31/2020	80

Additional Info:

[Anonymous]

You Can find an example of a solution in this github, which essentially uses the following Measure:

******************************************

Deliveriung the expected result (Your example Final Output had a mistake with james, who only had 20h workload in Week 23):

Hope this helps.

[amitchandak]

@venkatramp , refer id this can help in split

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