P3 Adaptive
David Hager’s guest post below reminded me of something I’ve been meaning to share for awhile. Here’s a feature of PowerPivot so tiny, so sensible, that I’ve had a very hard time internalizing that Excel lacks it. In fact, I think I’ve had to re-check Excel 3-4 times to confirm for myself that Excel doesn’t have it.
A Lasting Metaphor Many years ago, I was designing a feature for Excel 2003. And the VP of our division of Office, a man named Richard McAniff, didn’t like the […]
UPDATE: Uploaded a new version of the macro file that David provided that fixed a couple of small problems. Also, I fixed a typo (I had it as XSLM, not […]
“I mean, IF() I’m paying top dollar, I want a little production VALUE()” I bet you thought I was out of movie quotes for IF(VALUES()) didn’t you! If I had […]
“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 […]
These Two Columns Both Contain Dates, Right? Sure They Do! Relationships that should work, but aren’t? Here’s a quick tip, one that I think we’ll all need sooner or later. […]
You keep using that word, ‘Intelligence.’ I do not think it means what you think it means.-Average BI Consumer
Wow, what a trip. I barely slept. Let’s get right down to it: summary of my thoughts on the whole thing. 1) The Future of MS BI is (Basically) PowerPivot […]
UPDATE: My book, which explains the PowerPivot formula language (DAX), in down-to-earth fashion tailored to the Excel audience, releases November 6, 2012. I wrote it to fill the “DAX for Excel people” gap that existed between all of the previous books. People have been asking me seemingly forever to do this, I finally got around to it.
My book, which explains the PowerPivot formula language (DAX), in down-to-earth fashion tailored to the Excel audience, releases November 6, 2012. I wrote it to fill the “DAX for Excel people” gap that existed between all of the previous books. People have been asking me seemingly forever to do this, I finally got around to it.
COMMON QUESTION: “Hey, will this chart render unchanged in Excel Services, or will it look different?” MY STOCK ANSWER: “Hmm, I forget, let’s try it out” I hate giving that […]
Eat This Not That, PowerPivot Edition! Just like normal Excel, PowerPivot requires little or no premeditation – you can just jump right in and build something quite impressive. But if […]