Welcome to ONLC Training Centers

Microsoft BI Tools: DAX Formulas for Dynamic Tables

Microsoft Gold Partner
Class Dates
(click date for class times)
(click Enroll for locations)

Fee:  $995

Savings options:

 15 Day Pass
 Learning Credits
Need a price quote?

Follow the link to our self-service price quote form to generate an email with a price quote.

Need a class for a group?

We can deliver this class for your group. Follow the link to request more information.

Email Alert

Receive an email when this class is available as "Ready to Run" or "Early Notice" status.

Train from your home or office

If you have high-speed internet and a computer you can likely take this class from your home or office.

Microsoft BI Tools: DAX Formulas for Dynamic Tables Course Outline

This course is for individuals responsible for taking data and turning it into powerful reports. With DAX you can create reusable formulas the allow you to rapidly iterate and answer questions across multiple data tables and across different sources for complex reporting requirement.

This course covers essential information needed for DAX-related reporting requirements. Specifically, it leverages the DAX language, teaching how to build models that extend the capabilities Power BI, Excel, or SQL Server Analysis Services. Specific topics covered include proper understanding of DAX evaluation, controlling evaluation context, understanding relational functions, error handling within the data model, working with time intelligence calculations.

Software Used During the Class
This class is for users of either Power BI, Excel Power Tools, or SQL Server Analysis Services (SSAS). While all three products have a very similar DAX-related interface, the course will be taught using the Excel software. Users of Power BI and SQL Server should have no problems with the slight differences between products.

This course is aimed at Excel power-users, Power BI users who have a need to create dynamic reports that are based on the Excel / Power BI Data Model. Our Microsoft BI Tools: Get & Transform Data course is a great complement to this class and is also designed for users of Excel, Power BI or SQL Server. For details on this companion course, go to
Microsoft BI Tools: Get & Transform Data

While attendees do not need extensive prior experience with DAX formulas, it is recommended that they have taken either our "Analyzing Data with Power BI" or "Excel BI Tools" class or have similar experience.

Course Outline

DAX Functionality Review
Review Of Calculated Column
PivotTable Function
Review Of Measure
Rules Of DAX Measure
Evaluation Context
Formatting DAX Code

Controlling Content & Values
Controlling Values
Switch Function
Error Handling

Context Control Functions
Filter Function
All Function
Iterative Functions
Earlier Function
Calculate Function
Additional Uses Of The All Function

Contexts In Relationships
Working With Many Tables
Row Context & Relationships
Filter Context & Relationships
Values Function

Advanced Concepts
Circular Dependencies
Controlling Totals
Advanced Hierarchy Concepts

Time Intelligence Calculations
Working With Date Tables
Calculating Operating Periods
Working With Missing Periods
DAX Date Functions
Advanced Date Functions
Prior Year Functions
Moving Averages

Appendix : DAX Dashboard Techniques
Parameter Tables
Advanced Slicer Techniques
View outline in Word


Attend hands-on, instructor-led Microsoft BI Tools: DAX Formulas for Dynamic Tables training classes at ONLC's more than 300 locations. Not near one of our locations? Attend these same live classes from your home/office PC via our Remote Classroom Instruction (RCI) technology.

For additional training options, check out our list of Power BI Courses and select the one that's right for you.


Class Format
Class Policies
Student Reviews

Bookmark and Share

First Name

Last Name