Forum Discussion
Helper IIData modeling: Product / Customer Prices table - Star Schema
Hi everyone,
I d like to get your insights on how to include a table which store prices per product and customer in a star schema data model?
Products have a different price depending on which customer we are selling to and we need those prices to calculate revenue in our sales fact table.
best and looking forward your ideas,
kevin
1 Reply
Hi Kevin_Conseil ,
There are a few good blogs about how to create a star structure model, you can refer to them to create a model that suits your scenario.
Build Your First Star Schema Model in Action: Power BI Modeling Basics
Power BI Tips for Star Schema and Dimensional Data Modeling
In addition, you can share some sample data(exclude sensitive data) with Text format and your expected result with specific examples and backend logic. Later we can provide you a suitable solution.
Best Regards
