Introduction

Master the basics of DAX fast on this 1-day introduction to DAX course.

This is a hands-on course. It includes plenty of time to play with what you are being taught and ask questions.

Our expert instructors break the course into easily digestible sections and ensure that no-one is left behind.

By the time you finish, you’ll be very comfortable using DAX.

A complete introduction to DAX.
Plenty of time to ask questions and one-to-one attention.
Friendly expert trainers who make sure no-one is left behind.
All the materials and extras that you’ll ever need.
Ongoing support for 6 months after the course.

What Will I Learn?

Our expert instructors will have you creating your own functions in no time. 

By the end of this course, you will be able to confidently:

– Work with common DAX functions
– Define calculated columns and measures
– Use cross table lookups
– Define filters with tables functions

Am I Ready For This Course?

You do not need any prior experience with DAX to attend this course. 

In order to attend this course, you need to be an advanced Excel user and need a reasonable understanding of Power BI, equivalent to that reached on our intermediate Power BI course.

If you already have experience with DAX it is likely that our advanced DAX course will be most appropriate for you.

Course Detail

This one day course covers the following areas:

  1. Overview of the Language
  2. Common DAX Functions
  3. Defining Calculated Columns
  4. Defining Measures
  5. Aggregate Functions
  6. Cross Table Lookups
  7. Evaluation Context in Relationships
  8. Defining Filters with Table Functions
  9. Using Filters with the CALCULATE Function

The Training Day

We provide everything you need for a really fun productive day of training. You don’t need to bring anything. 

Our courses run from 9.30 am to roughly 4.30 pm with refreshments and biscuits throughout the day and a break for a tasty, freshly prepared lunch.

We offer a relaxed, supportive learning environment, fully air-conditioned facilities, and some of the nicest instructors on the planet.

Also, you’ll receive:

A full-colour A4 manual covering everything in the course to keep.
A USB stick so that you can take the course exercises home with you.
A Certificate of Attendance.