| The Magic of IF(VALUES()) |
| Written by Rob Collie |
| Wednesday, 09 March 2011 19:42 |
|
"I'm Dan Marino, and IF() anyone knows the VALUE() of protection, it's me." Boom! An Ace Ventura quote finally graces the blog. Yes folks, that fine work of American cinema did indeed feature Dan Marino reprising his real-world ad for Isotoner. But more importantly, I wanted to revisit this little two-function combo: IF(VALUES()). I've covered it before a few times, but generally in the context of covering something else. And since this is one of my favorite techniques, I think it deserves its own dedicated post. A series of posts, actually. Let's dig in. Read more... |
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?


