Relationship - Multiple tbl

[Anonymous]

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

[v-rzhou-msft]

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

[amitchandak · Accepted solution]

@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]

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

www.youtube.com/taik18