Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
47 | |
27 | |
23 | |
18 | |
15 |
User | Count |
---|---|
55 | |
34 | |
18 | |
17 | |
15 |