How to Create a Table in Power BI Using DAX

Updated on:

May 12, 2026

By:

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

Quick summary

Creating a table in Power BI using DAX lets you generate calculated datasets directly within your data model without importing external data. Using the New Table option in the Modeling tab, you can write a DAX expression to define and populate a table instantly.

Steps

Open Power BI Desktop and navigate to the Modeling tab.
Click New Table to open the table creation interface.
In the formula bar, type your DAX expression to define the table structure and values.
Click Commit to apply the DAX code and create the table.
Verify the result — for example, a table named NumberTable containing values from 1 to 10 is now created.
Check the newly created table in the Data pane to confirm it appears in your data model.

📌 Why this matters

Creating calculated tables using DAX in Power BI gives analysts the ability to generate dynamic, formula-driven datasets directly inside the data model — no additional data sources required. This is especially valuable for building date tables, reference tables, or custom aggregations that support complex reporting logic. Mastering the New Table workflow in the Modeling tab reduces dependency on ETL pipelines and empowers users to shape data on the fly. For teams working with Power BI, DAX-based table creation is a foundational skill that accelerates report development and improves model flexibility.

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