With Microsoft Power Query for Excel, you can aggregate the columns of a linked table. For example, you can aggregate the sum of order details for each order.
Aggregate a column
- Click the expand icon ( ) in a column header containing a related Table link. For example, an Order table has a related Order_Details Table link.
- In a Table link column drop-down:
- Click Aggregate.
- Hover over an aggregate function item such as Aggregates of UnitPrice .
- From the aggregate function drop down, select one or more aggregate functions. For example, Sum and Average.
- Click OK.
The table now contains a new aggregate column. The new column name is in the format <AggregateFunctionName> of <ColumnName>. For example, Sum of Order_Details.UnitPrice and Average of Order_Details.UnitPrice.