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
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
