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.
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.
Solved! Go to 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
@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
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 |
---|---|
48 | |
24 | |
20 | |
14 | |
12 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
18 |