Exercises for: Expanded Tables Purchase the entire course

23 December 2020 · Alberto Ferrari · 11 views

Mastering DAX Workshop

Exercises for: Expanded Tables

Jump to a chapter

14.10: Distinct Count of Countries (00:08)
14.20: Sales Quantity Greater Than Two (08:13)

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

14.10: Distinct count of countries
14.20: Sales quantity greater than two

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

Log in or purchase access to play the video.

Mastering DAX Workshop (2nd Ed)

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 oﬀer sales quotes/pro-forma invoices, and we accept purchase orders and bank transfers.
Your satisfaction is paramount: we oﬀer a no-quibble refund guarantee.
See pricing FAQ for more detail.

In collaboration with