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

Request More Information
Download Course Details
Course Details Only
Course Details & Schedule
Skip to Class Dates
  • 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
 

Get in touch to schedule training for your team
We can enroll multiple students in an upcoming class or schedule a dedicated private training event designed to meet your organization’s needs.

 



Do You Have Additional Questions? Please Contact Us Below.

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