Allocating workhours to months based on different conditions

[mjuamjua]

Hi!

I am trying to solve this problem: Here is a sample of my dataset.

ID	Germany Workhours	Italy Workhours	Spain Workhours	Start Day	End Day
Test1	20	300	400	15.7.2022	1.12.2022
Test2	10	120	450	15.8.2022	1.9.2022
Test3	120	120	1200	15.8.2022	1.1.2023

I need to make a visualization where x-axis is months and y-axis is workhours per country. Something like that

I need to divide startday-endday period into three smaller timeperiods. and allocate the workhours based on percentage: 50% for first one third, 40% for second and 10% for the last. Also it is important to notice that timeperiods can go over multiple months so the workhours needs to also divide based on months. I have tried many ways to solve this problem, but I think I am thinking this too hard and also I can't find good DAX commands to achieve the wanted result.

I will appreciate a lot if someone could help me!

[lbendlin]

Please show the expected outcome based on the sample data you provided.