Introduction to DAX for Power BI Desktop Users – Level 3

Reset

Live online events

This course takes an in-depth approach to the DAX language, teaching designers how to build models that extend the capabilities of source data for more in-depth, customized business intelligence solutions. Topics covered include proper understanding of DAX evaluation, controlling evaluation context, understanding relational functions, error handling within the data model, working with complex time intelligence calculations.

  • 07
    Dec
    2 days, Thu 8:00 AM CST - Fri 4:00 PM CST
    Online
    • $1,680.00 excl. GST + PST (SK)
    Registration closed
None of these dates work for you? Suggest another date & time

Description

Agenda

1 - Basic DAX Functionality

  • Review of Calculated Columns
  • Review of Measures
  • Rules of Evaluation
  • Evaluation Context
  • Formatting DAX Code

2 - Controlling Content & Values

  • Controlling Values – DAX
  • Error Handling

3 - Content Control Functions

  • Iterative Functions
  • The FILTER Function
  • The ALL Function
  • The CALCULATE Function

4 - Contexts In Relationships

  • Working With Many Tables
  • Row Context & Relationships
  • Elevated Calculated Columns
  • Filter Context & Relationships
  • Cross Filtering Issues

5 - Time Intelligence Functions

  • Calculating Operating Periods
  • To-Date Functions
  • Controlling Totals
  • Advanced Date Functions
  • Prior Year Functions

6 - Appendix – Advanced Concepts

  • Additional Uses Of The ALL Function
  • Advanced Data Tables
  • Working with Missing Periods
  • Working with Non-standard Years
  • Parameter Tables
  • Banding

Prerequisites

Data Model Design using Power BI Desktop – Level 2

Similar courses

Powered by Arlo training & Event Software