AUCKLAND (09) 378-0411       HAMILTON (07) 838-0700       WELLINGTON (04) 472-4830      CHRISTCHURCH (03) 365-5020      |      
Home Courses Mastering DAX

Courses


Mastering DAX

Length: 2 Days    Cost: $1,395 + GST    Version: Power BI

= Scheduled class    = Guaranteed to run    = Fully booked
Click on the dates to book online
CentreDecJanFebMar
Auckland
18
23
27
30
Hamilton
17
--
27
--
Christchurch--
20
--
30
Wellington----
13
--

Can't find a class in your area? Contact our sales team and request a class date.
Not sure about the version of your software? Click here to find out.
Want to know if this course is right for you? Assess your skills level with our online Skills Assessment tool.


About this Course

The goal of the course is to demonstrate all the features of DAX, providing the knowledge to write formulas for common and advanced business scenarios. Students will use DAX to solve real world scenarios that enhance reporting capabilities.

While DAX can be used across a variety of applications, this course will be taught using Power BI.



Audience


Have you been using DAX for a while? Are you drowning in Youtube videos? Tired of copying DAX expressions that you don’t understand? This training is aimed at Power BI, Power Pivot for Excel and Analysis Services developers who wish to gain a better understanding of DAX and the context behind it. Discover some of the lesser-known DAX functions, explore the different behaviours of similar functions (and discuss when to use each) and master your understanding of CALCULATE.

Prerequisites

Before attending this course you must:

  • have experience with Power BI equivalent to that covered in Power BI Essential Skills
  • understand reporting data models in Power BI, Excel PowerPivot or SSASS Tabular Model
  • have a basic understanding of DAX functions and syntax (ie able to use SUM, CALCULATE, or IF functions to create calculated columns and measures)

At Course Completion

Upon completion of this course, students will:

  • Create complex calculated measures to further extend the reporting capabilities of the Power BI data model
  • Understand the context of the DAX language and how it works within the report’s data model
  • Demonstrate proper use of the CALCULATE function and how it behaves
  • Use table functions to dynamically filter measures
  • Understand the properties of a Date table and use it to create time intelligence measures
  • Know what to look out for when using DAX in reporting

Course Outline


Module 1: Introduction to DAX

  • What is DAX?
  • DAX data types
  • Calculated columns
  • Measures
  • Naming conventions
  • Measures vs Calculated Columns
  • Handling errors
  • Aggregation Functions
  • Counting Values
  • Logical Functions
  • The SWITCH Function
  • Information Functions
  • MAX and MIN Functions
  • Mathematical Functions
  • DIVIDE Function
  • Using Variables
  • Rounding, Text, and Date Functions
  • Relational Functions

Module 2: Table Functions

  • Introduction to Table Functions
  • FILTER Function
  • ALL Function
  • ALLEXCEPT Function
  • Mixing Filters
  • DISTINCT Function
  • VALUES and ALLNOBLANKROW Functions
  • ISEMPTY Function
  • RELATEDTABLE Function
  • Tables and relationships
  • Calculated Tables

Module 3: Evaluation Contexts

  • Introduction to evaluation contexts
  • Filter Context
  • Row Context
  • There are always two contexts
  • Context errors
  • Working with evaluation contexts
  • EARLIER in nested row contexts
  • EARLIER and variables

Module 4: CALCULATE Function

  • Introduction to CALCULATE
  • CALCULATE examples
  • Filters are Tables
  • OR conditions in CALCULATE
  • Clear filter on one column only
  • CALCULATE Tasks
  • Ratios and Percentages
  • Variables and evaluation contexts

Module 5: Evaluation contexts and Relationships

  • Introduction to evaluation contexts and relationships
  • Row context and relationships
  • Filter context and relationships
  • CALCULATE examples
  • Filtering many columns
  • Filter arguments in CALCULATE
  • FILTER and CROSSFILTER Functions
  • HASONEVALUE Function
  • ALLSELECTED Function
  • Context transition
  • Automatic CALCULATE in measures
  • Equivalent Filter context
  • Circular dependency

Module 6: Building a Date Table

  • Introduction
  • CALENDAR Function
  • CALENDARAUTO Function
  • Mark as Date Table
  • Set sorting options
  • Multiple dates

Module 7: Working with Iterators

  • Introduction to Iterators
  • Useful iterators
  • MIN-MAX sales per customer
  • Statistical and Financial Functions
  • RANKX Function

Module 8: Time Intelligence DAX

  • Introduction to Time Intelligence
  • Aggregations over time
  • Year to Date Functions
  • Previous year and DATEADD Functions
  • PARALLELPERIOD Function
  • Running Total
  • Moving Annual Total
  • Semi-additive Measures
  • Calculations over weeks

 Print this page