RELATIONSHIPS IN POWER BI

How relationships work in Power BI.
In Power BI, relationships connect different tables of data, allowing you to analyze them together as if they were one through keys.

Types of relationships.

1. One-to-Many (1:*) A single record on the "one" side (the lookup or dimension table) can relate to many records on the "many" side (the fact table).

-One product → many sales transactions.

1. One-to-one (1:1)
   A single record in the first table is related to one and only one record in the second table.

2. Many-to-many (:):
   Multiple records in one table can relate to multiple records in the other. This type is generally handled using a "bridge" or "junction" table that creates a link between the two primary tables.