Forum Discussion
Anonymous
6 years agoNot applicable
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
- 6 years ago
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
mohammedadnant
Impactful Individual
6 years agoHi 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