How to Create a Column in Power BI: 1-Min Guide

How to Create a Column in Power BI

Updated on:

May 12, 2026

By:

Use this interactive demo to learn how to manually add a new column in Power BI Desktop.

Quick summary

Creating a column in Power BI using the Enter Data feature lets you manually define and load custom tables directly into your data model. This method is ideal for adding reference data or lookup columns without connecting to an external data source.

Steps

Go to the Home tab and click Enter Data to open the manual data entry dialog.
Enter your column names and corresponding values into the data grid.
Click the add icon to insert a new column into the table.
Add a name to your table to identify it within your data model.
Click Load to import the table and its columns into Power BI.

📌 Why this matters

Creating columns directly in Power BI using the Enter Data feature gives analysts and report builders a fast, no-code way to add custom reference data or lookup tables without relying on external data sources. This capability is essential for building flexible, self-contained Power BI reports that don't require database access or complex ETL pipelines. For teams that need to enrich their data models quickly, manually defining columns and loading them into Power BI Desktop saves time and reduces dependency on IT or data engineering resources.

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