Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
PowerBiInterest
New Member

Kapacity planning new tabel based on two tables

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:

PowerBiInterest_0-1624519469100.png

Date table:

PowerBiInterest_1-1624519553793.png

 

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

PowerBiInterest_2-1624519649802.png

Regards Anja

1 ACCEPTED SOLUTION
ryan_mayu
Super User
Super User

@PowerBiInterest 

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

pls see the attachment below





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

1 REPLY 1
ryan_mayu
Super User
Super User

@PowerBiInterest 

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

pls see the attachment below





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.