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.

Student Testimonials

Instructor did a great job, from experience this subject can be a bit dry to teach but he was able to keep it very engaging and made it much easier to focus. Student
Excellent presentation skills, subject matter knowledge, and command of the environment. Student
Instructor was outstanding. Knowledgeable, presented well, and class timing was perfect. Student

Click here to print this page »


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

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