Forum Discussion
Dim to Dim relationship
Hi Folks,
I need your help. I have two dim tables Customer and Products.
Product table(PPrd_id) and customers(I have two columns -P & Prdid (I have concatenated and created a new column in customer table PPrdid) and then joined with products. I want relations to be 1(product): M(customers), but currently, I am getting otherway round.
Hi Anonymous ,
As the online document.
The Cardinality option can have one of the following settings:
Many to one (*:1): A many-to-one relationship is the most common, default type of realtionship. It means the column in one table can have more than one instance of a value, and the other related table, often know as the lookup table, has only one instance of a value.
One to one (1:1): In a one-to-one relationship, the column in one table has only one instance of a particular value, and the other related table has only one instance of a particular value.
One to many (1:*): In a one-to-many relationship, the column in one table has only one instance of a particular value, and the other related table can have more than one instance of a value.
Many to many (*:*): With composite models, you can establish a many-to-many relationship between tables, which removes requirements for unique values in tables. It also removes previous workarounds, such as introducing new tables only to establish relationships. For more information, see Relationships with a many-many cardinality.
For more information about when to change cardinality, see Understanding additional options.
3 Replies
- VijayP
Community Champion
I Think the Table which is considered by Power BI as many have duplicates isnt it? then it gives in the same manner.
If not just share the snapshot of each table to give you further idea.
Regards
Vijay Perepa
please watch my Youtube videos at www.youtube.com/perepavijay
- amitchandak
Super User
Anonymous , Difficult to say without looking at Data.
What is the relation between customer and product?
Ideally one customer can be sold more then one product so if the product table is customer product then it will be 1 to M from customer to product
v-frfei-msftCommunity Support
Hi Anonymous ,
As the online document.
The Cardinality option can have one of the following settings:
Many to one (*:1): A many-to-one relationship is the most common, default type of realtionship. It means the column in one table can have more than one instance of a value, and the other related table, often know as the lookup table, has only one instance of a value.
One to one (1:1): In a one-to-one relationship, the column in one table has only one instance of a particular value, and the other related table has only one instance of a particular value.
One to many (1:*): In a one-to-many relationship, the column in one table has only one instance of a particular value, and the other related table can have more than one instance of a value.
Many to many (*:*): With composite models, you can establish a many-to-many relationship between tables, which removes requirements for unique values in tables. It also removes previous workarounds, such as introducing new tables only to establish relationships. For more information, see Relationships with a many-many cardinality.
For more information about when to change cardinality, see Understanding additional options.
