Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi!
So i am relatively new to PowerBi and i need to combine multiple tables to a dim_date (all dates table) which i have not been able to figure out in the last 2 days!
I have a table named AppResourceBookings which includes all dates and hours the staff members were booked for an appointment,
I have a table named AppResRota which includes all dates and Hours the staff members should be working.
I have a table named AppResBlocked which includes all the dates and horus the staff members were blocked (if something took longer than expected etc.)
I need to combine these all together on the dim_date Table to be able to measure the % when the staff member is in an appointment, available, blocked and to see which days he is working.
All the tables have the common table (ResourceID) for the staff members, a date table and then the value table.
I have been trying to join the tables together but with no luck! All help would be amazing!
All the best,
Pétur
Solved! Go to Solution.
Read up on the concept of inactive relationships and the DAX function USERELATIONSHIP()
Focus on the business questions you will need to answer - that will then impact how you need to wire the tables together.
Read up on the concept of inactive relationships and the DAX function USERELATIONSHIP()
Focus on the business questions you will need to answer - that will then impact how you need to wire the tables together.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
44 | |
21 | |
20 | |
15 | |
13 |
User | Count |
---|---|
45 | |
41 | |
39 | |
19 | |
19 |