Introduction to DAX


What Will You Learn?

  • 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


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.


Mitchell Pearson

BI Consultant and Trainer
As a Business Intelligence Consultant and Trainer for Pragmatic Works, Mitchell’s focus is on the full BI Stack (SSIS, SSAS and SSRS). In addition to the BI Stack, he also has experience with Data Modeling, T-SQL, MDX, Power Pivot and the Power BI Tools. Mitchell graduated from the University of North Florida in 2007 and is constantly expanding his knowledge on all things SQL Server.


What to Know Before the Class

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

Duration: 0


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