VTeach Training Partner
Your Training Partner
Follow Us:
Contact VTeach Training
Register for Training

Data Analysis Expressions (DAX)

Course Dates:

Call for Dates

Course Specifications

Course length: 1 Day

Course Fees: S$285.00 (Group Discount of 10% for 3 or more participants)

Course Objective:

This course is intended to expose the students to the technology of DAX and to familiarize them with functionality of DAX at an advanced level to produce sophisticated DAX calculations by use of the functions of DAX. This course is based on Excel Professional 2013 or higher.

Target Audience

This course is intended for Power Users, Business Intelligence Developers, and IT Professionals that will be involved with the development of Excel PowerPivot queries and tabular modeling.

Course Content

Lesson 1: Introduction to DAX 

  • DAX Syntax
  • DAX Data Types and Operator Overloading
  • DAX Operators
  • DAX Values


Lesson 2: Using DAX Functions 

  • Mathematical Functions
  • Statistical Functions
  • Logical Functions
  • Information Functions
  • Text Functions
  • Conversion Functions
  • Aggregation Functions
  • elational Functions

Lesson 3: Understanding Evaluation Contexts 

  • The CALCULATE Function
  • Filter Functions
  • Single Table Evaluation Context 
  • Multiple Table Evaluation Context

Lesson 4: Working with Dates 

  • Date Functions
  • Working with Calendars
  • Using Multiple Calendars

Newsletter Subscription

Connect with VTeach by subscribing to our mailing list