Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Phil
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
43 | |
25 | |
19 | |
16 | |
8 |
User | Count |
---|---|
58 | |
50 | |
44 | |
21 | |
19 |