What is row-level transformation vs column-level transformation?

< 1 min read

Row-level transformation means modifying or filtering individual records based on conditions.
In my project, we flagged orders with negative quantity as “Return” at row level.
We also removed rows with null mandatory fields like Order ID.
Column-level transformation means changing entire columns at once.
For example, converting all date text fields to proper date format.
Standardizing product names or trimming spaces from text columns.
Creating derived columns like Profit = Revenue – Cost also counts.
Row-level focuses on individual records; column-level focuses on entire attribute values.
Both are applied in Power Query during data preparation.
They ensure data quality and analytical consistency in dashboards.

Power BI Essentials