Introduction to DAX

Part Of The On-Demand Courses


  • To have the ability to add analytical value to data models by creating calculated columns and measures
  • To develop a strong understanding of how to work with time intelligence functions in DAX
  • To build the foundations necessary for authoring more complex DAX calculations
This course includes:
  • Course Description
  • Outline
  • Instructor
  • System Requirements
  • What to Know Before Class

Course Description

DAX is both a programming and query language that gives you the ability to extend what is possible in either your Power BI or Tabular data models. The Introduction to DAX course is designed to teach the fundamentals of DAX, while emphasizing the basic building blocks required to author more complex DAX calculations. This video-based course quickly moves from basic DAX functions to more advanced functions like CALCULATE and iterator functions like SUMX.


Click here for a downloadable PDF



Module 00 | Introduction to DAX
09m 02s total


Module 00A | Getting Started
09m 02s


Module 01 | Data Modeling Basics
34m 86s total


Module 01A | Overview
27m 28s


Module 01B | Tabular
07m 58s


Module 02 | What is DAX
29m 48s total


Module 02A | Overview
23m 30s


Module 02B | Tabular
06m 18s


Module 03 | Creating Calculated Columns
50m 55s total


Module 03A | Basics
27m 55s


Module 03B | Basics (Continued)
23m 00s


Module 04 | Navigation Functions
20m 08s total


Module 04A | Navigation Functions
20m 08s


Module 05 | Conditional and Logical Functions
29m 56s total


Module 05A | Conditional and Logical Functions
29m 56s


Module 06 | Creating Calculated Measures
40m 20s total


Module 06A | Creating Calculated Measures
40m 20s


Module 07 | Time Intelligence
36m 46s total


Module 07A | Overview
09m 12s


Module 07B | Time Intelligence Functions
27m 34s


Module 08 | Using X-Functions and A-Functions
17m 41s total


Module 08A | Using X-Functions and A-Functions
17m 41s


Module 09 | Table Functions
27m 20s total


Module 09A | Table Functions
27m 20s


Module 10 | DAX as a Query Language
21m 59s total


Module 10A | DAX as a Query Language
21m 59s



Training Content Manager

Mitchell Pearson has been with Pragmatic Works for 8 years as a Data Platform Consultant and the Training Content manager. Mitchell has authored books on SQL Server, Power BI and the Power Platform. Data Platform experience includes designing and implementing enterprise level Business Intelligence solutions with the Microsoft SQL Server stack (T-SQL, SSIS, SSAS, SSRS), the Power Platform and Microsoft Azure.


System Requirements

  • Microsoft Windows XP Professional, Microsoft Windows Server 2003, Microsoft Vista, Windows 7 or Windows 8
  • 1 GHz or faster CPU
  • 1 GB of available RAM (recommended 2 GB)
  • 20 GB of free hard drive space
  • SQL Server Developer, Standard or Enterprise Edition 2008/2008R2/2012/2014 (Many features discussed are enterprise/developer edition only)
  •  AdventureWorksDW2008R2 or AdventureWorksDW2012 databases installed on the instance

What to Know Before Class

A basic understanding of Excel functions is helpful, but not necessary for this course.


Great course material, presentation, and format. Very useful information that can be applied at work immediately.

David H.

Huge fan of this class and the T-SQL class. Both instructors are very clear and concise with their examples and start from the very beginning... which is much appreciated!


I enjoy these classes at my own speed.


Start your 7 day free trial

Pragmatic Works On-Demand Learning Platform gives you access to 60+ courses such as Power BI, Azure, SQL Server, Data Science, Business Intelligence Power Apps and more.

Instant Download | No Credit Card Required