Hi everyone,
I'm trying to show the numbers of days of vacation taken by the employees per week and per team. I have tried this potential solution but although it works fine for vacations per employee and per week, it does not add up days for teams : https://community.powerbi.com/t5/Desktop/Managing-absences-per-month/m-p/3144462#M1062939 (Thanks @Ahmedx ).
Here are a few samples of my data (the two tables have a relation through the EmployeeID) :
Table for the time off of each employee :
| EmployeeID | StartDate | EndDate |
| 1 | 2023-03-24 | 2023-03-24 |
| 1 | 2023-04-03 | 2023-04-07 |
| 2 | 2023-04-03 | 2023-04-14 |
| 2 | 2023-05-10 | 2023-05-12 |
| 2 | 2023-08-08 | 2023-08-10 |
| 3 | 2023-08-07 | 2023-08-11 |
| 4 | 2023-06-12 | 2023-06-12 |
| 4 | 2023-08-08 | 2023-08-08 |
| 4 | 2023-09-11 | 2023-09-13 |
| 5 | 2023-08-09 | 2023-08-18 |
Table for the teams :
| EmployeeID | Team |
| 1 | Team 1 |
| 2 | Team 1 |
| 3 | Team 2 |
| 4 | Team 2 |
| 5 | Team 2 |
Thanks you very much for you help !!
Joe.
