Calculated column

Concept

A calculated column is a column added to a Power BI table using a DAX formula; its values are computed row by row and stored in the model, increasing model size and refresh work.

Title graphic: Calculated column (Concept)

Type	Concept
Documentation	learn.microsoft.com/en-us/power-bi/transform-model/desktop-tutorial-create-calculated-columns

Key points about Calculated column

In Power BI the same number can be built as a calculated column or a measure, and they behave very differently. · Power BI Calculated Columns vs Measures …
A calculated column is stored inside the data model and follows every row. · Power BI Calculated Columns vs Measures …
The process in Power BI Desktop involves analyzing existing DAX and deciding between a new calculated column or a revised measure. · Bulk Rename Power BI Measures with PBIP

Episodes about Calculated column

Reduce Power BI Premium Costs with Better Data Models

2025-11-03 · Video on YouTube

Your dashboards aren’t just slow—they’re expensive. Every bloated column, lazy import, and tangled relationship silently taxes your Power BI Premium capacity and your team’s time. That inefficiency adds up to real money—often five figures a year. The cure…

Power BI Calculated Columns vs Measures - Simply Explained

2026-10-29 · Video on YouTube

You can build the exact same number in Power BI two different ways, and they behave nothing alike. One of them gets stored inside your data model and follows every single row. In this episode of Simply Explained you will learn: - Two Ways To Do The Same Thing…

Bulk Rename Power BI Measures with PBIP

2025-11-03 · Video on YouTube

In this episode, we dive into how to replace measures in Power BI using DAX, helping you simplify your data model, improve report performance, and create more accurate, maintainable calculations. We explain what measures are, why they’re essential for…

Timeline of episodes about Calculated column

Articles about Calculated column (2)

Why Power BI Calculated Columns Ruin Report Performance and Bloat Model Memory
2026-10-29 · Mirko Peters
Discover why overusing Power BI calculated columns bloats model memory and ruins report performance. Learn how to optimize your data model architecture.
Mastering DAX Evaluation Context: Why Power BI Isn't Just Excel
2026-08-13 · Mirko Peters
When transitioning from traditional spreadsheet applications to business intelligence tools, many analysts fall into a comfortable trap. They assume that data analy…

Frequently asked questions

What is the difference between a calculated column and a measure in Power BI?

A calculated column is stored inside your data model and follows every row. A measure behaves differently, and the real difference is where the calculation stands. · From the episode: Power BI Calculated Columns vs Measures …

Where does a calculated column live in a report?

It lives in the data model with your data, whereas a measure is placed and used differently in the report, as the episode explains. · From the episode: Power BI Calculated Columns vs Measures …

What is the difference between a measure and a calculated column?

Measures calculate results dynamically in reports, which makes them essential for interactive visuals. Calculated columns are computed per row in the model. The episode explains how to decide which one fits when replacing logic. · From the episode: Bulk Rename Power BI Measures with PBIP

Glossary

Community wiki

Short info above, community knowledge below: add practical tips, examples or corrections. New contributions are reviewed first; trusted members publish directly.

Experts and companies for this topic

Nobody has listed this topic yet. Add it to your profile.

Sources

Documentation: learn.microsoft.com/en-us/power-bi/transform-model/desktop-tutorial-create-calculated-columns
Feed for this topic (RSS): entity/calculated-column/feed.xml
M365.FM episodes on this topic: 3
Articles on this topic: 2

Maintained by Mirko Peters (Microsoft MVP) · Last updated: 2026-11-03