Using Time Intelligence in PowerPivot can appear scary when you first start using it and I’ve seen some weird and wonderful ways of attacking it, some that look like we’re calling into question the validity of the global phenomenon that is time and others that are quite simply brilliant.

It’s that time of the month again folks… you know… for the next installment in my series for CIMA Insight!

Equivalents of Excel’s Percentile, Quartile, and Median functions are perhaps the most significant omissions in Denali’s DAX statistical function library. Quartile and Median are actually special cases of percentile, and in this post, we calculate these special cases.

I occasionally look through the logs of what people were Googling (or Binging etc.) when they found their way to the blog.

I’ve always loved the concept:  we know the universe is essentially a lot “heavier” than all the things we can see

I get a reasonable number of questions in email each week, and rarely have time to respond to all of them.  Last week though I received a question that I […]

Well folks I haven’t had much time to play with the V2 Beta (aka CTP3) yet. A lot going on over the past week:

CTP3 Adaptive = “Public Beta” What the heck is a CTP, you ask? Well it’s a “Community Technology Preview.”

This will be a quick one. I think.

In part two, we left off with the observation that VALUES() can “trump” ALL() even when VALUES() is applied to a column that is not on the pivot:

OK, picking up from part one…

Let’s start with a simplified version of last post’s pivot – remove one of the row fields, and all of the measures but the base Total Sales measure:

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 […]

So How Many Servers Do I Need in My PowerPivot SharePoint Farm?
As people increasingly move up from just dabbling with the addin, and decide to start leveraging the publish/schedule/share/secure benefits of the PowerPivot for SharePoint infrastructure, I am getting this question more frequently.