Tecflix

Exercises for: The CALCULATE Function Purchase the entire course

23 December 2020 · · 26 views

Mastering DAX Workshop

Exercises for: the CALCULATE Function

Please complete the following exercises, in the suggested order, before watching this video in which Alberto explains how to solve them:

  • 05.05: Sales of red and blue products
  • 05.20: Understanding CALCULATE
  • 05.25: Sales of blue products
  • 04.20: Customers in North America (only ADVANCED exercise if you did not complete it before—see the solution video in Evaluation contexts section)
  • 05.15: Computing percentages

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

$480/year

Access all content on this site for 1 year.
Purchase
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