book a course

Our Training

Build the confidence and skills you need to succeed with our practical professional development and IT courses, led by expert trainers with ongoing support.
See all courses

Explore our courses

IT & Digital Skills

Professional Development

PD Training

Build confidence, leadership, and workplace skills with our practical professional development courses. Delivered in Perth or live online, with expert trainers and ongoing support included.

read more

Explore our programs

Communication

Leadership

Project Management

Qualifications

Advance your career with nationally recognised qualifications and practical training. Delivered in Perth or live online, with expert trainers and ongoing support.
Learn More

Explore our Qualificationss

Microsoft Power BI Advanced – Create Performance Measures with DAX

Microsoft Partner Power BI Logo
Free Post-course Support
100% Quality
Guarantee
Interactive
Learning
eCertificate of Attendance

Microsoft Power BI Advanced – Create Performance Measures with DAX

$1360per person

In Person

Location: Level 1 Cloisters, 863 Hay Street, Perth WA 6000
Time: 9:00 am to 4:00 pm
Duration: Two consecutive days

Join in-person at our vibrant Perth CBD training centre. Lunch and refreshments are provided for all in-person attendees. Our training centre is centrally located and easily accessible by public transport.

Course Overview

Course Overview

Create Powerful Power BI Measures Using DAX Techniques.

This course develops your skills in DAX (Data Analysis Expressions), enabling you to create accurate performance measures and advanced calculations in Power BI. Designed for users looking to move beyond the basics, you’ll learn how to write DAX to build custom measures, manage evaluation context, and apply calculations effectively within your data model to produce reliable, practical reports.

Dates

Book a course

Course Information

Course Content

Data Modelling Basics

  • Data storage versus data analysis
  • Data model schemas and useful table structures
  • Star Vs Snowflake schemas
  • Model guidelines
  • Date table guidelines

Overview of using DAX to create Performance Measures

  • DAX Overview
  • Formatting
  • Types of calculations (table, column, measure)
  • Data types and syntax
  • Using DAX to calculate columns in Row Context
  • Getting values from related tables using the RELATED function
  • The DIVIDE function
  • When calculated columns don’t work

Measures

  • Overview and guidelines for creating measures
  • Aggregator Functions – SUM, AVERAGE, etc
  • Evaluation Contexts
  • Using Row Context and Filter Context
  • Creating a measures table
  • Using measures instead of calculated columns
  • Iterator functions – SUMX, AVERAGEX, etc
  • Context transition
  • Contexts, relationships and filter propagation
  • Implicit Vs Explicit measures

Basic DAX Functions

  • Common maths functions
  • Date-times in DAX and common Date-time functions
  • Common text functions
  • Count functions

Table Functions

  • Using the FILTER function
  • Visualising table function results
  • ALL and ALLECEPT
  • VALUES and DISTINCT

Logical and Branching Functions

  • The IF function
  • AND, OR and NOT
  • The SWITCH function
  • The IFERROR function

The CALCULATE Function

  • CALCULATE Overview
  • CALCULATE and FILTER
  • Conditions in CALCULATE

Time Intelligence Functions

  • Overview of Time Intelligence functions
  • Built-in time intelligence functions
  • Creating … ToDate functions
  • The DATEADD and PARALLELPERIOD functions
  • Period comparison functions (eg Month on Month)
  • DAX Variables

Parameter Tables

  • Adding a ‘what if’ parameter
  • Creating and using Parameter tables
  • The SELECTEDVALUE function

Get in touch

Excel in business with our essential Power BI training and more. Whether you’re looking to upskill through training or need tailored support through our consultancy services, we’re here to help.

To learn more about our Microsoft Power BI course or how we can support your data goals, please contact us today or give us a call on (08) 9218 9059.

By the end of the workshop, participants will be able to:

  • Understand some of the options for data model schemas and table structures.
  • Understand how to work with different relationship types, including active and inactive, and how filter propagation works.
  • Understand and gain skills in incorporating disconnected table at higher levels (like budgets) and additional data tables into the model.
  • Understand DAX, the types of calculations available and its contexts, as well as gaining experience in writing DAX and formatting for easier readability and future modification.
  • Practical skills in using core DAX functions to create a range of typical, real-world performance measures.
  • Understanding of the main DAX ‘time intelligence’ functions and gaining skills in writing typical and custom time intelligence functions.

This is a technical course and requires extensive use of excel-like functions. You will require the following prerequisite knowledge and experience to successfully understand and apply the concepts:

  • Have experience in creating visualisations in Power BI.
  • Have experience in using Power Query to transform data into models.
  • Understand the basic database theory of One-to-Many relationships.
  • Have experience in using basic DAX in Power BI to create tables and add columns to tables.
  • Have competency in using Excel formulas and functions similar to the level of  Excel Formulas & Functions
    Here’s an example of a formula that you would need to be able to understand:
    IF(A1 > TODAY(), VLOOKUP(A2, SalaryTable, 2, FALSE), IF( A1 = TODAY(), VLOOKUP(A2, SalaryTable, 3, FALSE),  VLOOKUP(A2, SalaryTable, 4, FALSE)))

If you are unsure whether your level of skill is sufficient please contact ATI-Mirage on hello@ati-mirage.com.au or call 9218 9059.

“Very useful course, a difficult subject to tackle in such a short space of time and Steve did a great job, thank you!” – Debbie from NMHS

“The explanations on why things work the way they do behind the scenes, and why working through what the functions do as writing them is so helpful.” – Devon from WACHS

FAQs

What are Measures in Power BI?
Who should attend this Power BI DAX Measures course?
Is this course suitable after Power BI Essentials?
Will I learn CALCULATE and time intelligence?
Is this course practical or theoretical?