Connecting multiple tables that have the same ID but have different time inputs

[Anonymous]

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

[lbendlin · Accepted 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.