Advanced DAX

Advanced DAX - What you need to get started

Module 00 - Class Introduction 5 min.

Module 01 - Working with Variables 13 min.

Module 02A - Working with Filter Context (What is Filter Context?) 8 min.

Module 02B - Working with Filter Context (CALCULATE) 18 min.

Module 02C - Working with Filter Context (FILTER and ALL) 15 min.

Module 02D - Working with Filter Context (ALLEXCEPT) 8 min.

Module 02E - Working with Filter Context (Totals) 11 min.

Module 03A - Time Intelligence (YTD and MTD) 19 min.

Module 03B - Time Intelligence (Rolling Totals) 19 min.

Module 04A - Semi-Additive Measures 11 min.

Module 04B - Semi-Additive Measures (Opening and Closing Balance) 9 min.

Module 05A - Row Context (Understanding Row Context and Context Transition) 14 min.

Module 05B - X Functions 9 min.

Module 06 - Nested Row Context 17 min.

Module 07 - Error Handling 24 min.

Module 08A - Security (Basic) 20 min.

Module 08B - Security (Dynamic) 17 min.

Module 09A - Role Playing Dimensions (Multiple Table Import) 12 min.

Module 09B - Role Playing (USERELATIONSHIP) 14 min.

Module 10A - Advanced DAX Function (CONTAINS) 10 min.

Module 10B - Advanced DAX Function (FIND) 12 min.

Module 10C - Advanced DAX Functions (SEARCH AND SUBSTITUTE) 20 min.

Module 10D - Advanced DAX Function (ALLSELECTED) 7 min.

Module 10E - Advanced DAX Function (RANKX) 8 min.