Adding pivot columns in powerBI desktop using columns from different tables

Using PowerBI Desktop, I imported the following tables:

Table name: inventory
columns:

    item_code
    warehouse_code
    quantity

Table name: warehouses
columns:

    item_code
    location

The possibilities for location are:

    headquarters
    east_coast

What I would like to, is to have pivot columns, added to the inventory table, using the names in the location column of the warehouses table, and values from the quantity column of the inventory table. 

Any ideas how to do this?