Introduction to DAX for Excel 2016 Users – Level 4

Course Information

Duration: 2 days

Version: Excel 2016 L4

Price: $1,190.00



Learning Credits:


Check out our full list of training locations and learning formats. Please note that the location you choose may be an Established HD-ILT location with a virtual live instructor.


  • Live Classroom

Train face-to-face with the live instructor.

  • Established HD-ILT Location

Interact with a live, remote instructor from a specialized, HD-equipped classroom near you.​

  • Virtual Remote

Attend the live class from the comfort of your home or office.



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.


Data Model Design using Excel 2016 – Level 3


Target Audience:

Report Builders


Course Objectives:

  • Understanding of DAX evaluation
  • Controlling evaluation context
  • Understanding relational functions
  • Error handling within the data model
  • Working with complex time intelligence calculations


Course Outine:

Lesson 1 : Basic DAX Functionality

  • Review Of Calculated Columns 
  • PivotTable Functions 
  • Review Of Measures 
  • Rules Of DAX Measures 
  • Evaluation Context 
  • Formatting DAX Code

Lesson 2 : Controlling Content & Values

  • Controlling Values 
  • Switch Function 
  • Error Handling

Lesson 3 : Context Control Functions

  • Iterative Functions 
  • Filter Function 
  • All Function 
  • Earlier Function 
  • Calculate Function

Lesson 4 : Contexts In Relationships

  • Working With Many Tables 
  • Row Context & Relationships 
  • Filter Context & Relationships 
  • Values Function

Lesson 5 : Time Intelligence Calculations

  • Working with Date Tables 
  • Calculating Operating Periods 
  • Working With Missing Periods 
  • DAX Date Functions 
  • Advanced Date Functions 
  • Prior Year Functions 
  • Moving Averages

Lesson 6 : Appendix: Advanced Concepts

  • Circular Dependencies 
  • Controlling Totals 
  • Advanced Hierarchy Concept 
  • Additional uses of the ALL function

Lesson 7 : Appendix: DAX Dashboard Techniques

  • Parameter Tables 
  • Banding 
  • Ranking 
  • Advanced Slicer Techniques



SLI Main Menu