We move! Starting September 1st, our QUEBEC CITY training center will be located at 5400, des Galeries Blvd, Suite 500, 5th Floor, Québec (Quebec) G2K 2B4
MS426

DAX for Power BI

See the training dates
  • Duration 2 days
  • Regular fee 1 000
  • Preferential fee 900?
  • Locations
    • Quebec City
    • Montreal
  • New course
  • Laboratory
    course

Objectives

To provide the knowledge and skills required to use DAX expressions to resolve a wide range of analytical and data modeling issues.

Targeted audience

Professionals who use Power Pivot and/or Power BI Desktop to analyze data and wish to create dynamic, high-performance dashboards.

Prerequisite

Experience with Power BI.

Training Details

Content

  • Getting started with DAX
  • Introduction to DAX
  • Basics of data modeling
  • What is DAX
  • Creating calculated columns
  • Navigation functions
  • Conditional and logical functions
  • Creating calculated measures
  • Time Intelligence
  • Time intelligence functions
  • Using X functions and A functions
  • Table functions
  • DAX as a query language
  • Using variables
  • What is filter context?
  • Using filter context (CALCULATE, substituting filter contexts, FILTER, ALL, ALLEXCEPT)
  • CALCULATE and time intelligence (YTD, MTD,12 month rolling average, 3 month rolling average)
  • Semi additive measures
  • Overview of row context and transition context
  • Using iterator functions
  • Nested row context
  • Managing errors
  • Implementing basic security
  • Dynamic security
  • Role playing dimensions (importing several tables)
  • Role playing dimensions (USERELATIONSHIP)
  • Advanced DAX functions (CONTAINS, FIND, SEARCH, SUBSTITUTE, ALLSELECTED, RANKX)

Select the training date*

*Unless stated otherwise, all sessions are in French.
  • Quebec City

    January 9 to January 10 2020

  • Montreal

    January 29 to January 30 2020

  • Quebec City

    June 3 to June 4 2020

  • Montreal

    June 22 to June 23 2020

Trainer(s) assigned(s)