Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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 ...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

v-juanli-msft 

 

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.

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    v-juanli-msft any additional insight would be greatly appreciated