Next course begins May 6th

Advanced Dax for Power BI

Our Advanced DAX for Power BI course is designed for participants who are experienced in writing DAX but are looking to increase knowledge and skills in DAX (Data Analysis Expressions). The course will focus on the advanced and complex DAX concepts. The course will help you understand the more complicated and advanced principles of DAX.

What you'll learn

The course will provide participants with the key concepts of databases and structured query language (SQL). Participants will learn how to read and write simple and complex SQL statements.

Participants will gain a solid working knowledge of this powerful and universal database programming language. At the end of the course, delegates would have gained a solid understanding of relational databases and SQL (Structured Query Langauge).

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of DAX.

Course Content

DAX basics

  • What is DAX
  • Dax data types
  • Calculated Columns
  • Measures


Introduction to DAX

  • DAX basics
  • What is DAX
  • Dax data types
  • Calculated Columns
  • Measures
  • Naming convention
  • Measures Vs Calculated Columns
  • Aggregate Functions
  • Counting Values
  • Logical functions
  • The SWITCH Function
  • Information Function
  • MAX and MIN Function
  • Divide Function
  • Using Variables


Deep dive into CALCULATE

  • Introduction to Calculate
  • Understand the use of CALCULATE
  • Calculate Examples
  • Filters and Tables
  • OR conditions in CALCULATE
  • Clear filter on one column only


Table Functions

  • Introduction to table functions
  • FILTER Function
  • ALL function
  • ALLEXCEPT function
  • Mixing filters
  • DISTINCT function
  • ISEMPTY function
  • RELATED TABLE function
  • Tables and Relationships


Time intelligence functions

  • MTD, QTD, YTD, SamePeriodLastYear
  • Rolling totals for different periods
  • IF, HasOneValue
  • Using a Safe Divide Function
  • Using the Blank() Function
  • Build an Example Time Intelligence Report
  • Creating Dynamic titles
  • Using parameter table

Introduction to evaluation contexts and relationships

  • Row Context and Relationships
  • Filter Context and Relationships
  • CALCULATE Examples
  • Filtering many columns
  • HASONEVALUE Function
  • ALLSELECTED Function


Building a Date Table

  • Introduction
  • CALENDAR Function
  • CALENDAR AUTO Function
  • Mark as Date table
  • Set sorting options
  • Multiple Dates


Working with iterators

  • Introduction to iterators
  • Useful iterators
  • MIN-MAX Sales per customer
  • RANKX Function and examples


Dax Studio

  • Capturing and debugging queries with Dax Studio
  • Power BI referencing



  • Summary

Upcoming Dates

LagosMay 6th, 2024₦200,000
AbujaMay 27th, 2024₦200,000
LagosJune 3rd, 2024₦200,000
LagosJune 17th, 2024₦200,000
LagosJuly 1st, 2024₦200,000

Delivery Methods

Classroom Training

Unlock your potential with our classroom training courses. Our portfolio of business intelligence training courses are delivered by BI experts across Africa.

Online Training

Our online trainings (live instructor-led) are delivered by certified instructors and are designed to replicate a classroom experience which enables full interactions.

Onsite Training

Our onsite training team allows us to bring our skills and expertise to you. Onsite courses are developed in conjunction with you, ensuring your expectations are exceeded.

1-to-1 Training

With our one-to-one training you’ll not only receive the undivided attention of the trainer, but one-to-one training allows you to tailor the training to your specific needs.

From ₦200,000



Training multiple people?

Empower your teams with business intelligence training courses delivered by subject matter experts.

Apply for Advanced Dax for Power BI

Which date are you interested in?

Apply for Advanced Dax for Power BI

Which date are you interested in?