Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
DAX Calculation Groups
Rating: 4.7 out of 5(72 ratings)
612 students

DAX Calculation Groups

Unlock the power and flexibility of DAX Calculation Groups and Items
Created byRandy Minder
Last updated 12/2020
English

What you'll 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)

Course content

4 sections16 lectures2h 10m total length
  • Introduction1:28

    An introduction to the course

  • Overview3:23

    An overview of Calculation Groups

  • What problem is Calculation Groups trying to solve?13:06

    An in-depth discussion of what problem Calculation Groups is trying to solve

  • Calculation Groups to the rescue!3:38

    We've identified the problem, now we see how Calculation Groups solves it.

Requirements

  • You should have some basic experience with DAX

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!

Who this course is for:

  • Power BI and DAX developers