IniziaInizia gratis

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.

Questo esercizio fa parte del corso

Intermediate DAX in Power BI

Visualizza il corso

Esercizio pratico interattivo

Passa dalla teoria alla pratica con uno dei nostri esercizi interattivi

Inizia esercizio