×

TLGPBICAL - Introduction to DAX for Power BI Desktop Users - Level 3

This course takes an in-depth approach to the DAX language, teaching designers how to build models that extend the capabilities of source data for more in-depth, customized business intelligence solutions. Topics covered include proper understanding of DAX evaluation, controlling evaluation context, understanding relational functions, error handling within the data model, working with complex time intelligence calculations.

Click here to print this page »

Prerequisites


Data Model Design using Power BI Desktop - Level 2

Detailed Class Syllabus


Lesson 1 : Basic DAX Functionality


Review of Calculated Columns
Review of Measures
Rules of Evaluation
Evaluation Context
Formatting DAX Code

Lesson 2 : Controlling Content & Values


Controlling Values - DAX
M Language Custom Functions
Error Handling

Lesson 3 : Content Control Functions


Iterative Functions
FILTER Function
ALL Function
CALCULATE Function

Lesson 4 : Contexts In Relationships


Working With Many Tables
Row Context & Relationships
Elevated Calculated Columns
Filter Context & Relationships
Cross Filtering Issues

Lesson 5 : Time Intelligence Functions


Calculating Operating Periods
To-Date Functions
Controlling Totals
Advanced Date Functions
Prior Year Functions

Lesson 6 : Appendix - Power BI Functions M Language


Power BI Functions: M Language
Basic M Language Queries
M Language Syntax
Adding Columns
Duplication & Splitting Columns
IF Expression
Query Cleanup
M Language vs. DAX Functions

Lesson 7 : Appendix - Advanced Concepts


Additional Uses Of The ALL Function
Advanced Data Tables
Working with Missing Periods
Working with Non-standard Years
Parameter Tables
Banding