data model for forecast, inbound supply and stock level + date table

[Jakob_PBI]

Hi,

I need advice on how i can struture and combine my 3 tables + a date table.

I have these 3 tables:
Future_Inbound: shows incoming supply of new products

Forecast: shows forecasted demand in quantity of products

Stock_level: shows current stock level of products

Then i have a dax calculated date table.

How would you combine these three tables? Currently i am using a concatenated key between future inbound and forecast, which is: "Country - Product - Date" and then i create a many-to-many relation between inbound and forecast and then i join date to the datetable. But it just feels like the wrong approach.

how would you do it? 

[lbendlin · Accepted solution]

Do not join your fact tables directly. Use dimension tables (like the calendar, and a customer list) to control the fact tables.

[Jakob_PBI]

thanks i figured out to do this, maybe i can ask you another question =D

i asked the question here:
https://community.powerbi.com/t5/Desktop/Calculating-stock-level-value-from-last-month-new-demand/m-...

the new data model is like this for the sample:

[lbendlin]

The filter direction should be single, from the time dimension to the fact tables.