Business analysis glossary
Calculated Column
What it is
A calculated column is a new column added to a table in a data model or spreadsheet whose value is computed for each row from other columns, for example an age band from a date of birth or a profit from revenue minus cost. It is calculated when data is loaded and stored with the table.
Why it matters
Calculated columns help categorise and label data for filtering and grouping. In Power BI, they differ from measures, which are calculated at report time based on filters. Choosing between the two is a common source of wrong totals and a frequent interview question.
Example
The analyst adds a calculated column called delivery speed band that labels each shipment as same day, next day or later, based on dispatch and delivery dates. Managers can then filter and count shipments by band, while on time percentage stays a measure so it works under any filter.