Power BI

How to Create a New Table in Power BI (From Scratch) Easily 2026

Name: How to Create a New Table in Power BI (From Scratch) Easily 2026
Uploaded: 2026-07-15T04:00:18Z
Duration: 2 min 51 s
Description: Not every table in a Power BI model needs to come from an external source — sometimes you just need to build one directly inside the tool. This guide covers how to create a new table in Power BI from scratch using its built-in table creation features. It's useful for building small reference lists, lookup tables, or custom groupings that support your main data.

By Impran M N

Not every table in a Power BI model needs to come from an external source — sometimes you just need to build one directly inside the tool. This guide covers how to create a new table in Power BI from scratch using its built-in table creation features. It's useful for building small reference lists, lookup tables, or custom groupings that support your main data.

01Access table creation in Power BI

In the Modeling tab, select New Table, which opens a formula bar where you'll define the table using DAX.

02Define your new table

Use DAX table functions, such as a simple set of rows defined with DATATABLE or a table built from existing data with functions like SUMMARIZE.

03Add data to your table

Populate the table with the specific rows and columns you need, keeping it focused on the reference or lookup purpose you had in mind.

04Apply best practices for table management

Name the table clearly to distinguish it from imported data tables, and keep manually created tables to genuinely necessary use cases rather than full datasets.

FAQ

Frequently asked questions

When should I create a table manually instead of importing data?

Manual tables work well for small reference lists, like a set of status categories or bucket ranges, that don't need to come from an external source.

Do manually created tables refresh automatically?

If the table is built with a static DAX definition, it stays fixed, but if it references other tables that update, it will recalculate on refresh.

Can a manually created table have relationships with other tables?

Yes, once created, it behaves like any other table in your model and can be connected through relationships in the Model view.

Is DAX knowledge required to create a table from scratch?

Yes, since the New Table feature relies on writing a DAX expression, some basic familiarity with DAX syntax is needed to define the table's structure.