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.
Hi @dennydavis ,
Thanks for sharing.
Best Regards,
Jay
Hi @dennydavis ,
Thanks for sharing.
Best Regards,
Jay
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
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
125 | |
75 | |
65 | |
56 | |
55 |
User | Count |
---|---|
199 | |
104 | |
88 | |
79 | |
77 |