Forum Discussion
Helper IIICountry Codes - Two active relationship within the same file
Hi, I have a master file of country codes (3-alpha) and a table with two columns of country codes (origin and destination). As example, master file (GBR = United Kingdom) is now active with Origin column. How then do I make destination column active with this master file? I read about a bridge but don't know how to go about it.
I will appreciate your guidance. Thanks.
Sincerely,
Patrick
You may refer to the post below.
https://community.powerbi.com/t5/Desktop/Multiple-relationships-between-tables/td-p/622648
4 Replies
PGAThi apoetra, thanks, I do have one relationship created between the two tables. However, there is another column within the table that needs to have the same relationship. Country codes, say, GBR, is present in both columns. So, it's not unique per se. Thanks.
v-chuncz-msftCommunity Support
You may refer to the post below.
https://community.powerbi.com/t5/Desktop/Multiple-relationships-between-tables/td-p/622648
