Aggregate measures

Complete this exercise on DataCamp in in-browser Excel, or locally on your computer if you have Excel and Copilot.

Measures are what make DAX and Power Pivot very powerful analytical tools. Measures are calculations that evaluate expressions in the data model.

Aggregation functions, like COUNT(), SUM() and AVERAGE() summarize multiple individual data points into a single value. These are very similar to the functions in Excel.

Continue working in your current workbook. If you've lost progress, open 3_2_related_columns.xlsx from the Workbooks folder in the course materials.