Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
change the day name to workday number. unpivot work table and merge two tables.
pls see the attachment below
Proud to be a Super User!
change the day name to workday number. unpivot work table and merge two tables.
pls see the attachment below
Proud to be a Super User!
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |