Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Relationship Three Tables

I have three tables, Sales; Forecasr and Date (autocreated, used for all tables in the file), see below sample data I can create a relationship between Sales-Date and Forecast-Date but I also ...
Need Help
  • gmsamborn's avatar
    gmsamborn
    2 years ago

    Hi Anonymous 

     

    I added a dimension table for Company and made the appropriate 1:* relationships.

     

    My 3 Tables.pbix

     

    Let me know if you have any questions.

gmsamborn's avatar
gmsamborn
Super User
2 years ago

Hi Anonymous 

 

In Power Query, I picked the table that had the most different companies duplicated the query, removed all columns other than Company, and removed duplicates.  (You could to this for each table if there isn't one table that includes all companies.  In this case, you would repeat the above for each table, merging the results, and removing duplicates.)

 

Typically you would have more company-related information other that the key itself that you could use as a dimension table.

 

Does this help?