OK, let’s say you already installed v2, whether inadvertently or… advertently. And now you need to downgrade to v1, so that your workbooks function on your server

The Mr. Excel PowerPivot Forum has inspired me to change gears a little bit and focus more time on simple techniques that don’t break the DAX Spicy Scale

Enjoying the new forum! I’ve been spending some time on the Mr. Excel PowerPivot forum over the past few days and I must say I am enjoying the experience.

The other day I suggested to Bill Jelen that he might want to add a PowerPivot-dedicated forum on MrExcel.com.  I wasn’t sure what he would say, to be honest. 

You’ll often hear us Accountants referring to things like adjusting for timing differences or prepaying costs or deferring revenue.

I thought today was going to be a “handful of mini posts” kind of day but then this post blossomed into a bit more than I thought it would, which is a good thing.

There’s few, if any, reports that I consider to be more important than the Cash Flow Statement.

Our time machine that we developed in part one and part two still needs some explanation, so let’s dive in.

You remember the Great Precedence Project?  Well, I have shelved it for now, for two reasons:

Here’s a question that comes up with increasing frequency:  “PowerPivot seems kinda similar to Access in many ways, what’s the difference?” Why Does the Question Come Up? Some of you […]

The PASS Summit tends to be one of  Microsoft’s favorite venues for unveiling big news in the BI space.  As you may recall, the 2010 Summit revealed some amazing things for the PowerPivot world.