Using Power Query, you can aggregate one or more columns of a related table. For example, you can aggregate the sum of order details for each order. Data Preview of the Orders table in the Northwind OData feed. In this example, you aggregate the Order_Details column from the Northwind Orders table. More @Wikipedia
Hover over any link to get a description of the article. Please note that search keywords are sometimes hidden within the full article and don't appear in the description or title.