Forum Discussion

frippex's avatar
frippex
New Member
3 years ago

Relations between two tables

Hi guys, For the ease of it I will try to explain my scenario using Countries and Offices: - excel_countries.xlsx with a table called "Countries" (1 row per country) - excel_offices.xlsx with a ta...
Need Help
HarishKM's avatar
HarishKM
Super User
3 years ago

frippex Hello,
You can load both table and then create a relationship ( one to many relationship) in your power bi desktop software. 

 

 

Then your expected output will be like this.

 

 

Thanks

Harish M