MeasureCalculated ColumnIt is not storedStored in memoryCalculated on the flyCalculates at the time of Refresh reportConsumes CPUConsumes memoryUsually is a result of an aggregationRow by row calculation usuallyValue can be see while adding in the reportValue can be seen in the column in Data tabDAX usually is the best place for this calculationCan be done in Power Query in majority of casesExample: Sales Year to dateExample: Profit = Sales - CostSales YTD = TotalYTD(Sum(Sales), DateField.[Date])

Hi dennydavis , Thanks for sharing. Best Regards, Jay

Forum Discussion

Helper I

6 years ago

Solved

Measure	Calculated Column
It is not stored	Stored in memory
Calculated on the fly	Calculates at the time of Refresh report
Consumes CPU	Consumes memory
Usually is a result of an aggregation	Row by row calculation usually
Value can be see while adding in the report	Value can be seen in the column in Data tab
DAX usually is the best place for this calculation	Can be done in Power Query in majority of cases
Example: Sales Year to date	Example: Profit = Sales - Cost
Sales YTD = TotalYTD(Sum(Sales), DateField.[Date])