Forum Discussion
Building Schema/ Relationship for Resource Management
Anonymous , Booking, Utilisation, and Availability seems to Many to Many relations, that is one thing need to be avoided unless there is no other option.
There might a need of some intermediate table to make it work.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Thank you for your response.
Below is the sample dashboard I am working on and sample of what the raw data looks like for the 3 reports.
I was also thinking I might need a fact table/ intermediary table so that I can do the "One to Many" relationship but I dont know what the fact table should look like.
I tried doing a Resource Table that only contains the resource name and thier respective team but it is not solving the problem.