Aggregating multiple columns

As DAX is built around dealing with tables, aggregating single columns of table data is incredibly easy. All standard aggregation functions, such as SUM, AVERAGE, MAX, and MIN, take a column as input as well as their corresponding iterative aggregation functions, such as SUMX, AVERAGEX, MAXX, and MINX. However, sometimes performing aggregations against a single column is not enough. Sometimes we need to aggregate against multiple columns at the same time.

This recipe demonstrates how to perform aggregations across multiple columns simultaneously.

Getting ready

To prepare for this recipe, do the following:

1. Open Power BI Desktop.
2. Use an Enter Data query to create a table called R01_Table with the...