hello@ati-mirage.com.au

Microsoft Power BI Advanced – Create Performance Measures with DAX

Home / Microsoft Power BI Advanced – Create Performance Measures with DAX

This course is designed to develop your skills in DAX (Data Analysis Expressions) language to enhance data models, through the use of formulas and expressions. Power BI users who are want to get even more out of this popular tool will learn how to write code in DAX (Data Analysis Expressions) to enhance the data models, create custom performance measures, and create complex calculations. Learn how to incorporate these results into practical stunning reports to make decision making easier.

Course price includes:

Perth’s best IT trainers at Perth’s best CBD training centre
Free help desk support after your training
Interactive, practical and hands on learning
Comprehensive take-home training and reference manual with exercise files
Morning and afternoon refreshments, delicious café lunch
Certificate of Attendance
Our 100% quality guarantee

$1295per person

Duration

2 Days

Dates

Contact us for more information

Details

Outcomes

Prerequisites

Reviews

Details

Course Times

9am to 4pm

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

Outcomes

Prerequisites

Reviews