
An introduction to the course
An overview of Calculation Groups
An in-depth discussion of what problem Calculation Groups is trying to solve
We've identified the problem, now we see how Calculation Groups solves it.
An overview of the Tabular Editor
In this lecture we can a quick tour through Tabular Editor
We do a review of why Calculation Groups are useful and an alternative to using them
In this lecture we demonstrate how to create Calculations Groups and Items, and why they are so powerful
We continue our discussion with Calculation Groups and Items
We demonstrate how to change format strings dynamically, using Calculation Items
It's important to understand how DAX handles Calculation Items. We discuss that in this lecture.
Exercise 1
Exercise 2
Exercise 3
Exercise 4
Are you tired of creating perhaps 10 different base measures and then are faced with having to create versions for year to date, quarter to date, month to date, year over year, min, max and average etc. You have probably thought to yourself, there has got to be a better way. Well, there is with Calculation Groups.
Calculation Groups and Calculation Items are a relatively new feature in Power BI that allow you to prevent a proliferation of measures in your data model. The power of these is impressive and they can save you a tremendous amount of time.
We thoroughly cover how to create and use Calculation Groups and Items and also introduce you to Tabular Editor, which is the tool you will probably use when working with Calculation Groups.
Understanding Calculation Groups will make you a more proficient DAX developer!