relationship issue

[160475]

dears,

good day!!

i have 2 tables one has a list of branches but not unieque it has branch transaction so i might find branch number 1 600 times in that table 

and i have another table where the branch is unique starts from branch 1 to 600 how can i link both tables together ? 

thanks 

[Anonymous · Accepted solution]

HI @160475,

Perhaps you can try to create a bridge table with unique values to link two table records:

How to Join Many to Many with a Bridge Table in Power BI | Seer Interactive

Regards,
Xiaoxin Sheng

[Anonymous]

In the model view you can create a relationship by dragging "Branch Number" from one of the tables and dropping it on "Branch Number" of the other table. Alternatively, you can also use Manage Relatonships tab in the model view.

Regards,
Aditya