The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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]) |
Solved! Go to Solution.
do you have any questions?
@dennydavis , Are you sharing or asking some question ?
Also refer: https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/
m just sharing a blog post. Please like it