Forum Discussion
Helper IManaging absences per month
need to create another column in the calendar table
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
Super Userif you have a table where there is a date and last name of an employee who worked half a day, then I can divide these days by 2
Helper IHi Ahmedx,
It would still be coming from the same table, have updated it below:
Staff Name Start Date End Date Absence Category Duration
Aaron Anderson 06/06/2022 10/06/2022 Annual Leave 5.00
Aaron Anderson 18/07/2022 22/07/2022 Annual Leave 5.00
Aaron Anderson 12/08/2022 12/08/2022 Annual Leave 1.00
Aaron Anderson 26/08/2022 26/08/2022 Annual Leave 0.50
Aaron Anderson 12/09/2022 09/10/2022 Illness 19.00
Aaron Anderson 30/11/2022 09/12/2022 Annual Leave 8.50
So for row 4 you can see that half a day is used as Annual Leave, and for row 6, 8 and a half days were used as leave.
Would there be a way of referring to this Duration column in the measure?
Thanks,
Aidan
- Ahmedx
to determine from which month we need to subtract 0.5, then we need to know the date of the day on which the employee worked half a day
- aid928
Ah I see, so say we ignored the last row then and only focused on row 4 where we know the day the half day was worked. How would we then build that into the measure?