Tecflix

Exercises for: Table Functions Purchase the entire course

23 December 2020 · · 35 views

    Mastering DAX Workshop

    Exercises for Table Functions

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

    • 03.20: Percentage of sales
    • 03.10: Delivery working days
    • 03.40: Sales of products in the first week
    • 03.30: Customers with children

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

    Log in or purchase access to play the video.

    Table Functions
    Evaluation Contexts

    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 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