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.

CoreyP's avatar
CoreyP
Icon for Solution Sage rankSolution Sage
2 years ago

Don't use CALENDARAUTO. Use CALENDAR and provide the first and last date based on the minimum and maximum date that will exist in your model.