Get startedGet started for free

Field aggregation

Now that we've loaded DimCustomer and cleaned it up, let's create a visualization with it. Power BI automatically sums up numerical fields in a visualization. For example, the default is to show the sum of all the sale totals, rather than the average sale total. In this exercise, you will try a new aggregation.

If you lost progress, close any open reports and load 2_2_field_agg.pbix from the Exercises folder on the desktop.

This exercise is part of the course

Introduction to Power BI

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise