DAX Calculation Groups

Unlock the power and flexibility of DAX Calculation Groups and Items

Ratings 4.20 / 5.00

What You Will Learn!

The problem Calculation Groups were designed to solve
Using Calculation Groups in real-world scenarios
An introduction to Tabular Editor
Creating and change measure format strings at evaluation time
How to reduce, for example, 50 related measures down to 10 (or less)

Description

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!