Kapacity planning new tabel based on two tables

[PowerBiInterest]

Hi all

I am new to power bi, and are trying to create a new table in power bi.

I have one table displaying working hours based on a weekschedule

What i wish is to make a new table calculating availeble time.

Work week table:

Date table:

I like the folling output in power BI ofcause showing more dates (all from date table)

Regards Anja

[ryan_mayu · Accepted solution]

@PowerBiInterest 

change the day name to workday number. unpivot work table and merge two tables.

pls see the attachment below