Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

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?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×