perpetual monthly employee allocation using DAX or M

[jinokannen]

I have an employee allocation table like below 

Team Assignment
Member	Team	Active start	Active End
Member 1	Team 1	1/1/2019
Member 1	Team 2	1/15/2019	3/15/2019
Member 2	Team 1	1/1/2019
Member 3	Team 1	2/15/2019
Member 3	Team 2	3/15/2019	3/31/2019
Member 3	Team 3	3/10/2019

and I need monthly allocation of each member with respect to each team as below

Expected result
Member	Team	Month	Default Allocation
Member 1	Team 1	1	75%
Member 1	Team 2	1	25%
Member 1	Team 1	2	50%
Member 1	Team 2	2	50%
Member 1	Team 1	3	75%
Member 1	Team 2	3	25%
Member 2	Team 1	1	100%
Member 2	Team 1	2	100%
Member 2	Team 1	3	100%
Member 3	Team 1	2	50%
Member 3	Team 2	3	50%
Member 3	Team 2	3	50%
Member 3	Team 3	1	~56%
Member 3	Team 3	2	~16.5%
Member 3	Team 3	3	~27%

  few values at the end I ave given as as approximate (~), and the idea is to get a DAX or M which is smart enough to populate a table as above. Please help. Thanks in advance!!

[Greg_Deckler]

Generally when I have done this, there is additional information involved like how many actual hours an employee is spending on each project or perhaps some kind of default allocation table perhaps? From the information given, it seems like there would have to be some magical assumptions made to get to what you are looking for. 

[jinokannen]

Hi Greg, Thanks for the response. Yes i missed out that inforrmation in my question . Actually, if a resource is split in to 3 teams, its considered as 33% (nothing like 20%, 30%, 50% etc.)  from that day onwards ( if into only 2 teams, then 50:50). I know its a odd scenario, still if I could find a DAX/M solution for this, the admin job ( to update in Project management tool) become easy from calculating the percetage of allocation every time as it changes frequently across the year. And here always the allocation is equally distributed for a particular employee on all the teams he/she participating for that period of time. 

[jinokannen]

JFYI ...For my case, there are more than 200 resources and 23 active teams.