Congratulations!

Intermediate Power Query in Excel

Lyndsay Girard

Performance Analytics Consultant

Combining queries in Power Query

Illustration depicting multiple datasets after appending data

Illustration depicting two datasets before merging data

let
    MyTable = Table.FromRecords({
    [ID = 1, Name = "A", Result = 10],
    [ID = 2, Name = "B", Result = 5]})
in
    MyTable

Intermediate Power Query in Excel