| Thinking in DAX: Counting Products in the Current Status with PowerPivot |
| Written by Alberto Ferrari |
| Wednesday, 09 March 2011 19:42 |
|
One of my readers came to me with an interesting formula to compute in PowerPivot. Even if I dont normally post about very specific scenarios, I think this time it is interesting to write a blog post since the formula can be easily created, if you think at it in DAX, while it is very hard if you are still approaching it with an MDX or SQL mindset. Thinking in DAX is something that comes after a lot of formula authoring, something that all BI professionals should strive for, as Vertipaq in the new SSAS engine is approaching pretty fast! Read more... |
Author articles
- Clever Hierarchy Handling in DAX
- Understanding Circular Dependencies in Tabular and PowerPivot
- Video - Many-to-Many Relationships in DAX
- KEEPFILTERS: a new DAX feature to correctly compute over arbitrary shaped sets
- Tabular Parent/Child Dimensions: SumOfLeaves and the CALCULATE wall
Most Popular
- Step by step guide on installing PowerPivot for SharePoint on a single machine
- List of suggested datasets to test PowerPivot
- List of PowerPivot DAX functions with description
- How to install PowerPivot for Excel and list of know issues
- Microsoft Virtual Lab: PowerPivot for Excel 2010 Introduction
- List of PowerPivot DAX functions (short)
- Learning PowerPivot and DAX
- PowerPivot's impact on BI pros?
