Create a Calculated Column in Power Pivot

In Power Pivot, you can add new data to a table by creating a calculated column. The new column can then be used in PivotTables, PivotCharts, and reports just like any other column. Calculated columns require you enter a DAX formula. For example, you could create a new Total Pay column in a Payroll table by entering the formula =[Earnings] + [Bonus]. This adds values from the Earnings column in the same table to values from the Bonus column in the same table for each row. To learn more, see Calculated Columns in Power Pivot.

  1. In the table you want to add the new column to, scroll to and click the right-most column.

  2. In the formula bar, type a valid DAX formula, and then press Enter.

  3. Right click on the column header>Rename, and then type a name.

Note: Unlike Calculated fields, you cannot type a name into the formula itself.

Need more help?

Expand your Office skills
Explore training
Got It
Get instant Excel help
Connect to an expert now
Subject to Got It terms and conditions

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.