topic Managing absences per week and per teams in DAX Commands and Tips

Managing absences per week and per teams

jomnr — Wed, 22 Mar 2023 18:16:47 GMT

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 :

Table for the teams :

Thanks you very much for you help !!

Joe.

amitchandak — Thu, 23 Mar 2023 02:08:47 GMT

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

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

For calendar