Get startedGet started for free

ADDCOLUMNS()? No problem!

Although it is possible to create new columns with SUMMARIZE(), best practice is to add new columns to a table using the ADDCOLUMNS() function. In this way, the output will be consistent since ADDCOLUMNS() will always evaluate over the row context by default. In this exercise, you'll expand the CaliforniaPR table with the Profit Ratio from Chapter 2.

If you have lost any progress, close any open reports and load 3_2_addcolumns.pbix from the Exercises folder on the desktop.

This exercise is part of the course

Intermediate DAX in Power BI

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise