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
CentreAprMayJunJul
Auckland--
27
----
Hamilton----
18
--
Christchurch----
10
--
Wellington--
14
----

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

This is a complete course about the DAX language. The goal of the course is to teach all the features of DAX, providing the knowledge to write formulas for common and advanced business scenarios.



Audience


This training is aimed at users of Power BI, Power Pivot for Excel and Analysis Services developers.

Prerequisites

Before attending this course you should have experience with PowerBI or Excel PowerPivot or SSASS Tabular Model.

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

Module 9: Querying with DAX

  • EVALUATE syntax
  • FILTER and CALCULATETABLE Functions
  • SUMMARIZE AND SELECTCOLUMNS Functions
  • CROSSJOIN Function
  • GENERATE Function
  • Tables, relationships, and data lineage
  • ROW, LOOKUPVALUE, and CONTAINS Functions
  • TOPN Function
  • UNION, INTERSECT, and EXCEPT Functions
  • SUMMARIZECOLUMN and GROUPBY Functions
  • Query Measures
  • Parameters in Queries
  • DAX Measures in MDX queries

Module 10: Advanced Filter Context

  • Introduction to advanced Filter Context
  • Filter propagation
  • Context propagation
  • KEEPFILTERS Function

Module 11: Hierarchies in DAX

  • Introduction to Hierarchies
  • Parent-child hierarchies
  • Hiding levels in parent-child hierarchies

Module 12: Advanced Relationships

  • Introduction to advanced relationships
  • USERLEATIONSHIP Function
  • Multi-column relationships
  • Static segmentation
  • Dynamic segmentation
  • Working with different granularity
Many-to-many relationships

 Print this page