Get total working hours by week by location

[JockerBoy]

Hi guys,

I'm new at PowerBI.

But i have already a table with wours worked by location, by function and by employee.

I have also in separate tables the holidays of each country.

I would like to add one row for each employee with the total business hours includind the holidays by week.

How can i do this?

Thanks