Forum Discussion
Data Model Help - Multiple Reference Tables
I am having some trouble building my relationships to achieve the analysis I am trying to achieve.
In my model I have 4 different data sources:
- Budget
- Forecast
- Field Estimates
- Actuals
Each table has a list of properties that have an expense category and sum amount.
I built a master property table to reference all 4 table's properties so that I can analyze from one master property list.
I also built a master expense classification table so that I could similarly point each of the above table's category names to a single column entry.
I am to the point though where adding additional relationships between the source tables to the expense table are inactive, so my analysis is incomplete in the following way:
Am I thinking about this wrong or modeling beyond the capabilities of PBI? Do I have to merge some tables together?
3 Replies
v-juanli-msftCommunity Support
Hi Anonymous
In this way, your tables within Power BI are complex and hard to create measures/columns using several tables' data.
Based on my knowledge, we may append or merge four tables into one table or create link tables to connect four tables.
Though your screenshot show some tables and relationships, but it's hard to find the four table(you list before) from the screenshot.
I need to know what relationship between these four tables and whether "expense type" exists within one of these four tables or other table.
Best Regards
Maggie
Hi,
The four tables I am referencing in the problem are on the right-hand side of the screen shot. Each of those tables has a 'Category Name' column that relates it to the Expense Table. Similarly, each table has a 'Property Number' which relates it to the property table.
v-juanli-msft any additional insight would be greatly appreciated