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.

some_bih's avatar
some_bih
Community Champion
2 years ago

Hi Anonymous "using" Sales as actual and Forecast values could be tricky:

- if there are different level of granularity of data, like Sales on daily level but Forecast on Monhtly level- check granularity

- in your Date table there are no unique dates which are eventually in other dates tables like Sales or Forecast (maybe you have future dates for Forecast, but in Sales or Date table only actual dates) - check details

- Date table is not properly created - link for set up

-check relationships between tables

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi some_bih 

 

- Date table is generated from Min Sales date -> Max forecast + 120days (All dates should be covered)

- Granulartiy is same, individual dates

- All dates in date table is unique

- I have a 1-Many relationship for both Date-Sales and Date-Forecast

 

- Whats wrong with date table?

- What could be the issue of combining Sales-Forecast?

 

  • some_bih's avatar
    some_bih
    Community Champion
    2 years ago

    Hi Anonymous share file (dropbox, g drive... )