Easy Tech TutsHow to Create a New Table From Existing Table in Power BI (DAX Method) Easily 2026
By Impran M N
Sometimes the fastest way to get the summary or reference table you need in Power BI isn't a new data source, it's deriving it from a table you already have. This guide covers the DAX functions used to build a new table from an existing one and where that technique pays off in real reporting. It's aimed at users comfortable with basic DAX who want to level up their data modeling.
01Understand DAX functions for table creation
Familiarize yourself with functions like SUMMARIZE, ADDCOLUMNS, and FILTER, which are the building blocks for deriving a new table from existing data.
02Follow the step-by-step process
Use the Modeling tab's New Table option, write a DAX expression referencing your source table, and validate that the resulting structure matches what you expect.
03Optimize your data model with new tables
Use calculated tables sparingly, since they add to your model size, and prefer them for cases like summary or lookup tables rather than duplicating large datasets.
04Apply new tables to business scenarios
Common use cases include building a distinct list of categories for a slicer or creating a summarized table for a specific report page.
05Review additional tips for Power BI proficiency
Test your new table's performance on a large dataset before relying on it heavily, since some DAX table functions can be resource-intensive.
Frequently asked questions
What's the difference between a calculated table and a calculated column?
A calculated table creates an entirely new table using a DAX expression, while a calculated column adds a single new field to an existing table.
Does creating a new table with DAX increase file size?
Yes, calculated tables are materialized and stored in the model, so they do add to your Power BI file size, especially with large source tables.
Can a DAX-created table update automatically when the source data changes?
Yes, calculated tables recalculate whenever the underlying data refreshes, so they stay in sync with your source table.
When should I use SUMMARIZE versus ADDCOLUMNS for a new table?
SUMMARIZE is typically used to group and aggregate data, while ADDCOLUMNS is better for adding calculated fields onto an existing table structure.
Watch the full walkthrough
The same steps, demonstrated on screen from start to finish.
