Create calculated tables

  • 4 minutes

Calculated tables are a function within DAX. Most of the time, you can import data into your model from an external data source. However, calculated tables provide intermediate calculations and data that you want stored as part of the model rather than as part of a query. You can use calculated tables, for example, to cross join two tables.

Tasks in this unit include: Conceptual graphic of the tasks in this module.

To create a calculated table, go to Table view in Power BI Desktop, on the left side of the report canvas. Select New Table from the Table tools tab to open the formula bar.

Type the name of your new table, the equal sign, and the calculation that you want to use to form the table. Your new table appears on the Data pane in your model.

Screenshot of the New Table button and the resulting table.

After the new table is created, you can use your calculated table as you would any other table in relationships, formulas, and reports.

For more information, see: Using calculated tables in Power BI Desktop.