Forum Discussion
Relationship - Multiple tbl
Hi Team,
I have to merge two different static table ,
1) merge to ID to ID
2) merger to Region to Region
how to do this relationship.
Thanks,
KV's
Anonymous , I think you need to merge twice
Table 1-2 in Table 1
Then Table 1 and Table 3
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
3 Replies
- mohammedadnant
Impactful Individual
Hi Anonymous ,
No need of merge, just relationship is enough.
connect
Table1 Cat-n to Table2 Cat-n (One to One relationship)
Table1 Region to Table3 Region (Many to One Relationship)
then use table visual to bring the required column in 1 table to display.
if you find any erros pls let me know.
Thanks & Regards,
Mohammed Adnan
- amitchandak
Super User
Anonymous , I think you need to merge twice
Table 1-2 in Table 1
Then Table 1 and Table 3
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Hi Anonymous
Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.
Best Regards,
Rico Zhou
