weekly average from period between 2 dates table

[phil78]

hello to everybody

I have a table with 4 columns:

member_Id | start date | end date|  status 

and a day by day calendar in another sheet

I can, thanks to @v-jiascu-msft ,

https://community.powerbi.com/t5/Desktop/Count-distinct-between-two-date-with-date-slicer-for-line-c...

count the number of people each day and slice by category or whatever.

I need now to compute a weekly average like this  :

if a personn belongs to the table for only 3 days in a week, it will add only 3/7 for  this particular week.

Furthemore, it would be great to look after the working days  on one side and the weekend on the other side, or the holidays, or any category in my calendar.

I can't  do it in a day-by-day table because it would lead to make a huge number of rows.

thanks to everyone

Phil

[Greg_Deckler]

Seems like a variation of Open Tickets. https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364#M147

Instead of SUM you would use AVERAGE.