How to Create a Calculated Table in Power BI

Updated on:

May 12, 2026

By:

Use this interactive demo to learn how to build a calculated table in Power BI using DAX.

Quick summary

A calculated table in Power BI is created using a DAX formula in the Table view, allowing analysts to generate derived datasets without modifying the source data. This step-by-step process uses the New Table option and the DAX expression editor to define and commit the calculated table directly in Power BI Desktop.

Steps

Open Power BI Desktop and navigate to the Table view.
Click New Table to open the DAX formula bar.
Write your DAX (Data Analysis Expressions) formula in the empty expression field.
Click the check icon to apply and commit the DAX expression.
Power BI generates the new calculated table based on your formula.

📌 Why this matters

Calculated tables in Power BI enable data analysts to create derived, DAX-powered datasets directly within their reports without altering source data or relying on external ETL processes. This feature is essential for building complex data models, bridging fact and dimension tables, and running advanced aggregations using DAX expressions. Teams that master calculated tables can significantly reduce report refresh times and simplify their data model architecture. For organizations standardizing on Power BI for business intelligence, knowing how to create calculated tables is a foundational skill that unlocks more scalable and maintainable analytics workflows.

Your product deserves an interactive demo

Start free

How to Uninstall Power BI

How to Compare Two Measures in Power BI

How to Compare Months in Power BI