What is derived column creation?

Parthiban Kannan

Updated on February 9, 2026

< 1 min read

Derived column creation means generating new fields using existing data.
We calculated Profit = Sales Amount minus Cost Amount.
In my project, order aging was derived using current date minus order date.
Fiscal month and quarter were created from transaction date.
Customer segment was derived based on purchase frequency.
Delivery status was created using dispatch and delivery dates.
These columns were built in Power Query during transformation.
They reduced manual calculations in reports.
Business users directly consumed ready KPIs in dashboards.
So derived columns convert raw data into analytical metrics.