Forum Discussion
relationship issue
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
- Anonymous4 years ago
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
2 Replies
- AnonymousNot applicable
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 - AnonymousNot applicable
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