Introduction to DAX for Power BI Desktop Users - Level 3

Price
$1,300.00 USD

Duration
2 Days

 

Delivery Methods
Virtual Instructor Led
Private Group

Course Overview

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.
  • Top-rated instructors: Our crew of subject matter experts have an average instructor rating of 4.8 out of 5 across thousands of reviews.
  • Authorized content: We maintain more than 35 Authorized Training Partnerships with the top players in tech, ensuring your course materials contain the most relevant and up-to date information.
  • Interactive classroom participation: Our virtual training includes live lectures, demonstrations and virtual labs that allow you to participate in discussions with your instructor and fellow classmates to get real-time feedback.
  • Post Class Resources: Review your class content, catch up on any material you may have missed or perfect your new skills with access to resources after your course is complete.
  • Private Group Training: Let our world-class instructors deliver exclusive training courses just for your employees. Our private group training is designed to promote your team’s shared growth and skill development.
  • Tailored Training Solutions: Our subject matter experts can customize the class to specifically address the unique goals of your team.

Course Prerequisites

Data Model Design using Power BI Desktop – Level 2

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
 

Upcoming Class Dates and Times

May 2, 3
7:00 AM - 3:00 PM
ENROLL $1,300.00 USD
Jul 11, 12
7:00 AM - 3:00 PM
ENROLL $1,300.00 USD
Sep 19, 20
7:00 AM - 3:00 PM
ENROLL $1,300.00 USD
 



Do You Have Additional Questions? Please Contact Us Below.

contact us contact us 
 
Contact Us about Starting Your Business Training Strategy with New Horizons