Exercises for: Calculation Groups Purchase the entire course

23 December 2020 · · 19 views

Mastering DAX Workshop

Exercises for: Calculation Groups

Please complete the following exercises, in the suggested order, before watching this video in which Alberto explains how to solve them. Best of all, Try to complete them when you are confident with all the topics covered in the course, as these almost-final exercises cover a lot of different DAX topics.

09.10: Time calculations
09.20: Multiple calculation groups
09.30: Sold versus delivered
09.40: Min, Max and Avg calculation group
09.50: Top and bottom products

You can download all exercise files from here (only available to Full Access Subscribers).

Log in or purchase access to play the video.

  • Introduction to Mastering DAX 2nd Edition 5-min Free—Watch Now

  • Introduction to DAX 1-hour 46-min Watch with Free Subscription

  • Exercises, Labs, Demos, and Presentation Slides 52-min

  • Exercises for: Introduction to DAX 52-min Watch with Free Subscription

  • Table Functions 1-hour 9-min

  • Exercises for: Table Functions 44-min

  • Evaluation Contexts 57-min

  • Exercises for: Evaluation Contexts 29-min

  • The CALCULATE Function 1-hour 4-min

  • Exercises for: The CALCULATE Function 49-min

  • Advanced Evaluation Contexts 56-min

  • Exercises for: Advanced Evaluation Contexts 1-hour 5-min

  • Iterators 41-min

  • Exercises for: Iterators 39-min

  • Building a Date Table 37-min

  • Time Intelligence in DAX 1-hour 20-min

  • Exercises for: Time Intelligence in DAX 46-min

  • Hierarchies in DAX 37-min

  • Querying with DAX 1-hour 58-min

  • Exercises for: Querying with DAX 47-min

  • Data Lineage and TREATAS 13-min

  • Expanded Tables 34-min

  • Exercises for: Expanded Tables 15-min

  • Segmentation 36-min

  • Exercises for: Segmentation 14-min

  • Many-to-many Relationships 35-min

  • Exercises for: Many-to-Many Relationships 13-min

  • Advanced Filtering 49-min

  • Relationships at Different Granularities 1-hour 20-min

  • Additional Exercises 27-min

  • Calculation Groups 1-hour 27-min

  • Exercises for: Calculation Groups 57-min

Purchase a Full Access Subscription

Individual Subscription


Access all content on this site for 1 year.
Group Purchase

from $480/year

For small business & enterprise.
Group Purchase
  • You can also redeem a prepaid code.
  • Payments are instant and you will receive a tax invoice straight away.
  • We offer sales quotes/pro-forma invoices, and we accept purchase orders and bank transfers.
  • Your satisfaction is paramount: we offer a no-quibble refund guarantee.
  • See pricing FAQ for more detail.
In collaboration with
Project Botticelli logo Oxford Computer Training logo SQLBI logo Prodata logo