Weekly Headcount from Start/Stop Dates

[tnsparks]

Emp #	Start Date	End Date	Status
1	2/5/22	6/5/22	Active
1	6/5/22	7/15/22	Active
1	7/15/22	12/30/22	Active
2	7/24/22	11/14/22	Active
2	11/14/22	2/5/23	Active
2	2/5/23	7/13/23	Active
3	6/3/23	7/13/23	Active

Example of my data above.

I want to find a weekly active headcount so I can find the average of the year by taking the weekly counts. So I want to look at any weekending and know how many employees were active on that date. But my employee data is structered with these start and stop dates, not weekly. How do you suggest is the best way for me to get these weekly active headcounts weekly from the current data? I am a bit stuck...

[Ahmedx]

pls see this

https://community.powerbi.com/t5/Desktop/Managing-absences-per-month/m-p/3144973#M1063068

or

https://exceleratorbi.com.au/how-many-employees-by-period/