| When to Use Measures vs. Calc Columns |
| Written by Rob Collie |
| Thursday, 07 February 2013 21:57 |
|
It's such a fundamental question. When you need to write a PowerPivot formula, which kind should you write - a calculated column or a measure (now renamed "calculated field" in 2013)? Well, there is no perfect 100% answer to this question. But there are a handful of crucial differences and guidelines that make your choice clear 95% of the time. And the other 5% generally don't matter. So let's get to those guidelines and differences, shall we? Read more... |
Latest Author Articles
- Pareto Analysis the Easy Way
- Adding a Minimum Threshold Slicer to "Stores That went negative" Technique
- Showing Only Months/Weeks/Etc. When at Least N Stores Showed a Certain Behavior
- Named Sets and "Asymmetric" Pivots: Showing Different Measures for Different Years
- HASONEVALUE vs. ISFILTERED vs. HASONEFILTER
