Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Jakob_PBI
Frequent Visitor

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

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? 

 

Jakob_PBI_0-1682078889642.png

 

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

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

View solution in original post

3 REPLIES 3
lbendlin
Super User
Super User

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

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:

Jakob_PBI_0-1682680952446.png

 

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

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.