In Power BI, cardinality refers to the relationship between two tables in a data model. It describes how many unique values from one table are related to unique values in another table. There are three types of cardinality commonly used in Power BI:
- One-to-One (1:1):In a one-to-one relationship, each record in one table is related to exactly one record in another table, and vice versa. This means that there is a unique match between the two tables based on a common key column.
- One-to-Many (1:M):In a one-to-many relationship, each record in one table can be related to multiple records in another table, but each record in the other table is related to only one record in the first table. This is the most common type of relationship in data modeling.
- Many-to-Many (M:M):In a many-to-many relationship, each record in one table can be related to multiple records in another table, and vice versa. This type of relationship is implemented using a bridge table or junction table to break down the many-to-many relationship into two one-to-many relationships.
Data Scientist | Senior Recruiter
1y#cfbr
--
1yThank you!!!!!!!!