Forum Discussion
Relationship between three tables
Hello,
I have an issue with showing data from three tables:
Dates
Resource (User information)
Resourcing (future time committed to a project).
Resources is connected to Resourcing by the user ID, while Resourcing is connected to dates by the week commencing.
Resources shows how many days someone is able to work in a week [Working Days], Resourcing shows how many days they have booked [Days Booked].
In a table, I want to show days remaining with a measure = [Working Days] - [Days Booked]. However, [Working Days] will only show a value if there is an entry for [Days Booked] that week. It makes sense as there is no relationship between Resource and Dates tables, but I'm not sure how to resolve it. Any help would be much appreciated.
Thank you!
1 Reply
You conveniently omitted to mention that this is a composite data model, with your fact table coming from another dataset.
Usually you don't want to allow the fact table to talk back to the dimension table. Please explain your reasoning.
