Merge Tables in Power Query M

Looks up matching columns from a second table, similar to a SQL left join.

Merging & AppendingIntermediatemergejoinlookup

Power Query M code

let
    Source = Orders,
    MergedQueries = Table.NestedJoin(Source, {"CustomerID"}, Customers, {"CustomerID"}, "CustomerDetails", JoinKind.LeftOuter),
    ExpandedCustomerName = Table.ExpandTableColumn(MergedQueries, "CustomerDetails", {"CustomerName"}, {"CustomerName"})
in
    ExpandedCustomerName

Notes

Replace Orders and Customers with the names of your own queries, and CustomerID with your join key.

Requirements

Two queries that share a common key column.

How to use this snippet

In Power BI Desktop, choose Transform data to open Power Query, then open the Advanced Editor on a query (or start from a blank query).
Paste the snippet and replace the placeholder names (tables, columns, file paths) with your own. Check the requirements above first.
Run it through the Power Query M Formatter to tidy the layout.

Related Power Query M snippets

More Power Query M resources

Browse all 145 snippets in the Power Query M Code Snippets, or search the library for something similar to Merge Tables.