Forum Discussion
Modeling Relationship
i want to create a relationship between the stores and sale table. however, by doing so, it will create an ambiguity error. my main goal is to create a relationship between these 3 tables,...
Hi Anonymous
Do you have keys in your dimension table for the store, and do you have a key in your sales table for the store the sale was made in?
Your output does not seam to be that hard, but this depneds on the make up of your tables and data.
Are you using this to model your schema? Understand star schema and the importance for Power BI - Power BI | Microsoft Learn