Columns vs Measures
Part of the Power BI Basics section of Coddy's Power BI journey. Lesson 21 of 28.
A calculated column is a new column whose formula is worked out once per row and stored.
Line Total = Sales[Quantity] * Sales[UnitPrice]In a column, Sales[Quantity] is this row's quantity: the row context.
A measure has no current row; it aggregates the rows its filters allow.
Challenge
Add a calculated column Line Total to Sales: each row's quantity times its unit price.
All lessons in Power BI Basics
1Meet Power BI
What Power BI IsTables, Rows and ColumnsYour First ChartSum, Count and AverageFilters and SlicersRecap - Mia's First Report4Calculated Columns
Columns vs MeasuresIF in a ColumnText ColumnsLooking Up with RELATEDColumns Feed MeasuresProfit and MarginWhen to Use WhichRecap - Profit by Category