B PowerBI Quick Start : Joining two data files

This PowerBI quick start film illustrates how to join two data tables using two keys (country and year).


This PowerBI desktop five minute quick start film requires no other software.

Streaming service link
Vimeo (no adverts) PowerBI Join on Two Keys
YouTube (sub titles) PowerBI Join on Two Keys
Bilibili (in China) PowerBI Join on Two Keys


As PowerBI is being constantly improved, new versions are published monthly, the slides and videos in this course may have slightly different user interfaces to your version of the software. However, the principles and visualization methods will be the same, or very similar, for other PowerBI versions and any visualization toolset you wish to try.

You can also merge two files using keys in Excel using the same type of join operation, in case you are using the PowerBI service which does not support the join operation.