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 

 

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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

gmsamborn 

Could you advise on how to generate the dimension table? 

 

Outcome seams to solve the issue I have