Forum Discussion
Helper IVCalculate available time from resource table, resource_availability dim and bookings fact tables
Helper IVThank you very much for your replay. I do have couple of questions.
First One is that Create a Relationship between Date Table and Bookings Table: This relation is many to many with week numbers between Date table and bookings table right?
Second I am getting the following error while trying to write the measure. Could you please let me know what is the reason behind it.
Community ChampionLet's address your questions one by one:
1. Relationship Between Date Table and Bookings Table:
The relationship between the Date table and the Bookings table typically isn't a many-to-many relationship based on week numbers. Instead, it's typically a one-to-many relationship where each date in the Date table can have multiple bookings in the Bookings table.
However, if you want to consider week numbers for some calculations, you can create an additional column in both tables that represents the week number, and then establish a relationship based on that. But for the context of your previous questions, a direct relationship between the Date table and the Bookings table based on the date column should suffice.
2. Error Message:
You mentioned that you're encountering an error while trying to write the measure. To provide guidance on resolving the error, I'd need to see the specific error message you're receiving.
Please provide the exact error message or describe the issue you're facing in more detail. This will help me understand the problem better and offer a solution or workaround accordingly.