What is calculated column conceptually?

< 1 min read

A calculated column is a new field added to a table using a formula or expression.
It is computed row by row based on existing columns in the model.
In my project, Profit Margin = (Revenue – Cost) ÷ Revenue was a calculated column.
Order Aging = Today’s Date – Order Date is another example.
It stays in the dataset and can be used in visuals, filters, or measures.
Calculated columns are created using DAX in Power BI.
They are useful when derived values are needed for every row.
Unlike measures, they are stored in the model and increase dataset size.
Business logic is embedded directly in the dataset for consistent reporting.
So it provides precomputed metrics for analysis and visualization.

Power BI Essentials