Forum Discussion
Kevin_Conseil
Helper II
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 whic...
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