Managing absences per week and per teams

[jomnr]

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.

[amitchandak · Accepted solution]

@jomnr , Have a date tablw with week , month , qtr etc column, This HR or between date logic should help

Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

Power BI Dax Measure- Allocate data between Range: https://youtu.be/O653vwLTUzM

For calendar

https://community.powerbi.com/t5/Community-Blog/Creating-Financial-Calendar-Decoding-Date-and-Calend...
https://medium.com/chandakamit/cheat-sheet-calendar-of-any-standard-month-just-one-variable-apart-5e...
https://amitchandak.medium.com/cheat-sheet-power-query-financial-year-calendar-5ceaacb520f1
DAX Calendar - Standard Calendar, Non-Standard Calendar, 4-4-4 Calendar
https://www.youtube.com/watch?v=IsfCMzjKTQ0&t=145s
Power BI Date Table: https://www.youtube.com/watch?v=cN8AO3_vmlY&t=18180s