Create Measure of available hours per month

[Syndicate_Admin]

Community

I use your help in ideas of how to create a measure to measure the number of hours in a month a person is at 100%

I have a table with the number of working hours in a month for each of the agents, and separated into three shifts

And I also have a list of Sharepoint where incidents are added during the month, such as>
-Vacation
-Disabilities
-Overtime
etc.

I make sure that month by month I add or subtract the number of hours available to calculate the availability of monthly hours.

There is already a table where there is an estimate of minutes it takes to solve each incident according to several pre-established categories.

I thank you in advance for the help.

Adolf E
Costa Rica

[Syndicate_Admin]

Thank you and attach some sample data

The agents have an ordinary day and the idea is that through this list they add or subtract hours of the corresponding day

Event start	Event end	Agent name	Event type	Total Hours	Number of days
5/16/2023	5/16/2023	Agent 4	Sick leave	8	1
5/22/2023	5/26/2023	Agent 14	PTO	1	5
5/22/2023	5/23/2023	Agent 7	PTO	16	2
5/4/2023	5/4/2023	Agent 2	PTO	8	1
5/18/2023	5/18/2023	Agent 2	PTO	8	1
5/15/2023	8/15/2023	Agent 17	Maternity License	1	90
4/23/2023	4/23/2023	Agent 10	Overtime	3	1
5/1/2023	5/1/2023	Agent 10	Overtime	6	1
5/8/2023	5/8/2023	Agent 10	Overtime	3	1
5/15/2023	5/15/2023	Agent 10	Overtime	3	1
5/14/2023	5/14/2023	Agent 4	Overtime	4	1
5/15/2023	5/15/2023	Agent 4	Overtime	4	1
5/22/2023	5/22/2023	Agent 5	Overtime	6	1
5/12/2023	5/12/2023	Agent 11	Overtime	1	1
5/6/2023	5/6/2023	Agent 11	Overtime	1	1
5/5/2023	5/5/2023	Agent 11	Overtime	4	1
4/29/2023	4/29/2023	Agent 11	Overtime	4	1
5/13/2023	5/13/2023	Agent 1	Overtime	4	1
5/12/2023	5/12/2023	Agent 1	Overtime	4	1
5/5/2023	5/5/2023	Agent 1	Overtime	3	1
4/29/2023	4/29/2023	Agent 1	Overtime	3	1
4/29/2023	4/29/2023	Agent 14	Overtime	8	1
5/3/2023	5/3/2023	Agent 11	PTO	8	1
5/4/2023	5/4/2023	Agent 4	PTO	8	1
5/12/2023	5/12/2023	Agent 4	Overtime	4	1
5/29/2023	5/29/2023	Agent 10	PTO	8	1
5/29/2023	5/29/2023	Agent 15	PTO	8	1

If an agent asks for a leave it is subtracted from the number of hours available for the month, but if he did overtime they are added.

In turn, each agent takes Support tickets that are equivalent to a certain amount of time according to the type of client, and the result would be to take out of their available time of the month, and number of tickets taken, how much was the percentage of the time they spent working on these tickets.

I hope it has been the most explanatory

Thanks in advance

Adolfo CR

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...