Change Academy
Training
Training Courses Leadership and Personal Development Systems and Office Applications Project Management Public Training Programme
About Contact Insights Tools Podcast
Power BI DAX Calculations and Measures training course hero image – Learn advanced DAX functions for data modelling.

Power BI – DAX Calculations and Measures

Learn how to write DAX formulas that deliver deeper insight, smarter time intelligence and fully dynamic reporting. This advanced course helps you build confident, accurate Power BI calculations.

In this course, you will learn how to:

  • Create calculated columns and build reliable data models
  • Write effective DAX measures for flexible reporting
  • Use CALCULATE and FILTER to control evaluation context
  • Apply time intelligence for period comparisons
  • Use IF, IS and SWITCH for conditional logic
  • Organise and manage your measures for cleaner workflows

Who is this course for?

Experienced Power BI users who already build basic reports and want to create more advanced, dynamic calculations. Ideal for analysts, managers and professionals responsible for business reporting.

Enquire Now

“I definitely would recommend the course to others. It was a very clear and concise introduction to where and when you would use different DAX methods.  The most useful part was that it encouraged us to think critically and apply the skills ourselves, rather than just providing all the answers upfront. The course struck a good balance and helped uncover and fill gaps in my knowledge.”

Rebecca Laidlaw – Specialist Advisor, Natural Resources Wales

“I would recommend the course. There was just enough content, and the supporting workbook is a very handy resource to have. I was given enough time to complete each task and Susan was a very clear and helpful trainer. I found all the course content useful and personally don’t feel anything needed improving. Another Power BI course that I really enjoyed.”

Nicola Brotherton – Specialist Programme & Planning Officer, Natural Resources Wales

“Yes, I would recommend the course because it expands on the previous foundation and advanced Power BI courses with useful learning around DAX. The training was really good, and the trainer is great at explaining things clearly. The most useful part was seeing examples with different data and then having hands-on practice to apply what we had just learned. It was really useful and built my confidence with DAX.”

Sam McLaughlin – Flood Warning & Informing Officer, Natural Resources Wales

Frequently Asked Questions

Course Outline

Course overview

Duration: 1 day (6.5 hours)

Objectives 

By the end of the course you will be able to:

  • Create calculated columns
  • Create date calculations
  • Create and use measures
  • Organise measures
  • Use the CALCULATE function
  • Use the FILTER function
  • Calculate period by period differences
  • Use the IF function and IS functions
  • Use the SWITCH function

Content

Creating Calculated Columns

  • Power Query custom columns vs DAX columns
  • Creating DAX calculated columns
  • Using Related

Working with Dates

  • Date calculations
  • Extracting date information

Creating Measures

  • Implicit vs Explicit Measures
  • Building measures
  • Using DAX
  • Common DAX functions
  • Using SELECTED VALUE

Organising Measures

  • Creating a measures table
  • Adding measures to a Measure table
  • Creating sub folders in a table

Using CALCULATE

  • Using the CALCULATE function
  • Adding the ALL context
  • Using the FILTER context

Time Intelligence Functions

  • Using the Quick measure
  • Calculating previous period
  • Period on period increases
  • % period on period increases
  • Using DIVIDE

Using IF and IS Functions

  • Using the IF function
  • Using IS functions
  • Using AND and OR

Using SWITCH

  • Using the SWITCH function

Get in Touch

Still have questions about this course?

Click Enquire Now and our team will share full details on content, dates, and pricing — and help you decide if it’s the right fit for you or your organisation.

Enquire Now

Related Courses

Power BI - Advanced Reporting

Expand your Power BI knowledge and take your reports to the next level.

View the course outline
Power BI – Introduction

Learn how to use this powerful tool to import and clean data and create some amazing visuals.

View the course outline
Excel – Mastering Formulas and Functions

Ideal for those already using Excel but who really want to get to grips with formulas and functions.

View the course outline

Additional Insights

Continue your learning with related articles, case studies, and podcast episodes that explore how these skills are applied in real-world contexts.

Explore More Training Options

Public Training Programme

Explore our current selection of public courses, available as convenient and cost-effective virtual sessions.

Engage with expert instructors and a diverse peer group in an interactive, online learning environment.

Ideal for those valuing flexibility and affordability, our public courses are ideal where you only have small numbers requiring training and offer training from the comfort of your home or office.

Check Public Dates

Full Training Catalogue

We deliver a wide range of training across Leadership, Personal Development, Project Management, and IT applications. Many organisations choose us because they can source both technical and people-focused training from one trusted provider.

Courses can be tailored to your organisation’s needs, making it easier to upskill teams consistently across different areas. Whether you want to build management capability, strengthen project delivery, or boost everyday software skills, you’ll find relevant options in our catalogue.

View our Leadership and Personal Development Course Catalogue
View our Systems and Office Applications Course Catalogue
View our Project Management Course Catalogue