Job schedule

Good night people.

I'm racking my brain to solve a problem.

Situation:

I have a work schedule in which I have some comics that make up a variation of the time scale (Vacations, Leave, shifts)

I need to calculate on the basis of these separate tables how many people will be available day by day.

My architecture in the Power query makes tying relationship through the employee's record.

I appreciate promptly help.