Forum Discussion
Data Model - is my setupo correct?
I have simple data model but I need to know if I plan it correctly. But first, quick explainer.
I have 5 tables:
New pricelist and old pricelist:
which are sold.
But products combined together make also an assembly so I also have a table of assemblies:
and to decide which product goes into which assemble in which amount I have a table:
With New pricelist, Old pricelist and TAssemblies I create a dim Products and assemblies table:
where column type is the information if it is a basic Product or Assembly
First I would kindly ask for Your help to know what relationships I should have?
Is this ok?
Further my goal would be to:
Calculate the price of basic product
Calculate the price of an assembly
Display in table visual the price for each Product and Assembly in dim Products and assemblies
If You need a file please find it here: Correct data model.pbix
Thank You in advance.
Hi Fistachpl ,
To avoid one to one and cross filter direction in both ways - modify to one to many relationships between tables:
1) dim products and assemblies ->* New pricelist
2) dim products and assemblies ->* old procelist
5 Replies
would not use Bi-directional filtering on the one-to-one from New/Old prices to Dim Product and then test the results
Hi Fistachpl ,
To avoid one to one and cross filter direction in both ways - modify to one to many relationships between tables:
1) dim products and assemblies ->* New pricelist
2) dim products and assemblies ->* old procelist
Hi Fistachpl
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
Thank you.Hi Fistachpl
May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.
Thank you
