Advanced DAX functions and concepts


In this course, you’ll learn how to master the advanced concepts and intricacies of DAX (Data Analysis Expressions). You’ll learn how to work with dates and how to create variables. You’ll understand how relationships work & you’ll learn all about DAX’s evaluation contexts. You’ll apply key concepts through case-study style learning, with concise lessons and applied assessments. C reated & customized for Chartered Accountants Ireland by

Venue details:  
Online EU, ,
Start date & time:  
03 December 2018 00:00
End date & time:  
01 January 2022 00:00
By registering for this course you have accepted the terms and conditions
Training ticket cost:  
3.00 Training Tickets accepted
CPD hours:  
Speaker details
No speakers have been associated with this event.


Product type:  
CPD online course
Technology and data

Who Should Attend?

This is an advanced course, and is suited to learners who already have a basic knowledge of DAX. You should know how to write formulas in DAX, and have some experience of using common DAX functions, in particular Calculate. This course will be of interest to any business professionals, such as accountants, management consultants and analysts who want to master DAX formulas.

Course Overview

This Kubicle course contains 13 lessons, 3 exercises and 1 Exam. It covers the following topics:

  • Date Functions
  • Data Tables
  • Time Intelligence
  • Working with Variables
  • Understanding Cross Filtering
  • Relational Functions
  • Filtering Functions
  • Understanding the Row Context
  • Multiple Row Contexts
  • Understanding Filter Contexts
  • Context Transition

Key Outcomes

Once you’ve completed this course, you’ll have a thorough understanding of the principles behind DAX formulas. You’ll also have an understanding of the data model used in Power BI, and you’ll be able to perform time intelligence analysis. The skills you’ll learn in this course will help you create more detailed DAX formulas, and help you reduce errors, giving you an excellent command of DAX.