Calculated Column vs Measure

[dennydavis]

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])

[v-jayw-msft · Accepted solution]

Hi @dennydavis ,

Thanks for sharing.

Best Regards,

Jay

[az38]

@dennydavis 

do you have any questions?

[amitchandak]

@dennydavis , Are you sharing or asking some question ?

Also refer: https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/

[dennydavis]

m just sharing a blog post. Please like it