DAX Calculation Groups
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)
- You should have some basic experience with DAX
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
Microsoft Certified Professional:
Exam 70-778: Analyzing and Visualizing Data with Microsoft Power BI (January 2019 - 80% score)
Exam PL-300: Power BI Data Analyst (December 2022 - 80% score)
Snowflake Core Certification Exam (April 2021 - 90% score)
Seasoned database engineer (OLTP, data warehouses, operational data stores), tabular modeling, business intelligence development, Power BI, Snowflake and KQL. 20 years of software development using a variety of Microsoft technologies, mostly C#.
2016 Nominee for the First Solar Business Enablement CEO Award for Analytics Tools & Methods Infrastructure.
StackOverflow reputation of 46,000 (top 1%)