Excerpts from PowerPivotPro School

Since it’s been the primary focus of my time lately, for today’s post I thought I’d share two excerpts from the upcoming PowerPivotPro School.

Intro to CALCULATE()

The first one is the complete and uncut introduction to the CALCULATE function:

That’s only the intro of course.  There is a lot more on CALCULATE obviously.  Even the “basics” consume quite a bit more time in the course, but I thought you’d like to see this first part.  I hope it helps some of you even if you don’t choose to join the course.

How Measures Are Calculated – Three Minute “Montage”

Chronologically, this clip occurs before CALCULATE in the course.  This is from the module called “Warmup and Fundamentals.”  It’s 3 minutes of “highlights” spliced together from a longer, 20 minute section:

Whereas the first video above is at “normal speed,” this one moves faster simply because I’ve edited out a lot of the more complete description and background.  The actual course moves more deliberately.

Sign Ups Open Until August 15th

If you’re interested in joining us for the course, signups remain open until August 15th.  Hope to see you there:



I’m getting a lot of questions about how the course is structured and delivered.  I’m compiling a FAQ and should post that tomorrow.