A Power BI Technique Mined from the Power Pivot Archives
Below, you will find one of our all-time favorite Power BI techniques. In the ten (yes ten) years we’ve been operating this site, we’ve written over 1,000 articles on Power BI. Hard to imagine - even for us - but true.
Years ago, we first wrote up this technique in the context of Power Pivot – Power BI’s cousin and predecessor, which we like to call “Power BI in Excel.”
Since the two products share the same brains (DAX and M), this technique is more relevant today than ever. Everything below is 100% legit for Power BI – the same data model “shape,” the same DAX, etc. – but now you can use it to power up your Power BI visuals, and not just PivotTables. Enjoy!
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.