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 ,
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
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.
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.