Advanced DAX in Power BI - Practical Workshop
A two-day workshop focused on advanced DAX techniques in Microsoft Power BI. Participants will explore evaluation contexts, the CALCULATE function, Time Intelligence, calculated tables, KPIs, and using DAX beyond Power BI. The program combines data modeling knowledge with hands-on exercises on real-world analytical scenarios, with AI-assisted formula generation and query optimization elements.
DAX is the essential tool for every professional working with Microsoft Power BI - from simple measures to advanced analytical models handling millions of records. Mastering evaluation contexts, Time Intelligence functions, and calculated tables enables the creation of professional management reports, KPIs, and comparative analyses at a level unachievable with standard formulas.
Advanced DAX in Power BI - Practical Workshop is a 2-day EITT training program, delivered on-site or remotely - depending on participant preferences. The program is designed for professionals with foundational Power BI and DAX knowledge - sessions combine theory with intensive hands-on exercises, with AI-assisted formula generation and query optimization elements.
Topics covered include:
- DAX evaluation contexts and advanced use of the CALCULATE function
- Time Intelligence - running totals, YoY and MoM period comparisons
- Calculated tables, virtual relationships, and window functions
- KPIs, calculation parameters, and query performance optimization
- DAX beyond Power BI - EVALUATE statement, Excel export, database querying
Upon completion, participants will be able to independently create advanced analytical models in DAX, optimize query performance, and use DAX as a query language beyond the Power BI environment.
Benefits
- Master advanced DAX evaluation contexts - row context, filter context, and execution context
- Learn to create complex measures using CALCULATE and variables
- Understand Time Intelligence techniques for period comparisons (YoY, MoM)
- Gain the ability to build calculated tables and virtual relationships
- Learn to create rankings, window functions, and advanced filtering
- Understand best practices for DAX query performance optimization
- Master the use of DAX beyond Power BI as a query language
Who is this training for?
Prerequisites
- Working knowledge of Microsoft Power BI Desktop
- Experience creating basic measures and calculated columns in DAX
- Understanding of data modeling fundamentals and relationships in Power BI
- Ability to create reports and visualizations in Power BI
Training program
DAX Fundamentals and Concepts
- What is DAX and where to use it
- Multidimensional analysis and data analysis concepts
- Measures, calculated columns, calculated tables - key differences
- DAX evaluation contexts: row, filter, and execution context
Functions and Calculated Columns
- Creating and modifying calculated columns
- Conditional functions
- Operator usage and precedence
- Text, date, and time functions
- Data types, data formats, and conversion functions
- Counting, aggregating, and grouping functions at row and column level
- Lookup functions across active, inactive, and unrelated relationships
- Error handling functions
- Using functions to change row and column context
- Creating calculations at the visualization level
Data Model and Relationships
- Best practices for data model design
- Dimension tables
- Relationships, cardinality, filter direction, and hierarchies
- Active and inactive relationships - activating user relationships
- Cross-filtering through one-directional relationships - CROSSFILTER function
Measures and Variables
- What measures are and how to create them
- Measure vs. calculated column
- Row-level X aggregation functions in measures
- Filter function in measures and using CALCULATE
- References to slicers
- Variables and parameters in DAX
Calculated Tables in DAX
- Creating calculated tables in DAX
- The "Filter as a table" concept
- Creating virtual tables for calculations
- Adding filters to tables - adding filter context
- Removing filters from tables - removing filter context
- Selective filter removal - partial context removal
- Unique values
- Creating temporary tables, adding aggregated values
- Building rankings using DAX
- Advanced filtering in the CALCULATE function
- Using virtual relationships
- Joins in calculated tables: cross, left, and natural
- Grouping functions in tables and measures
- Window and ranking functions
Time Intelligence in DAX
- Creating calendar and auto-calendar tables
- Running totals in YQMD and YWD contexts
- Period comparisons: YoY, MoM, and parallel periods
- Time Intelligence functions and year-to-date analysis
- Working with YQMD and YWD layouts
KPIs and DAX Code Optimization
- Best practices for working with DAX code
- Defining variables in code
- Comments and readable code structure
- Calculation parameters - parameter value tables
- Query performance analysis - query logging
DAX Beyond Power BI
- DAX as a query language - converting DAX to Power BI format
- SUMMARIZECOLUMNS function in practice
- The EVALUATE statement
- Using keywords to generate objects
- Querying relational databases
- Exporting query results to MS Excel
- The SELECTEDMEASURE function
Delivery Methods
Online
- Convenience of participating from anywhere
- Interactive live sessions with trainer
- Materials available for 30 days
- No travel costs
On-site
- Direct contact with trainer and group
- Intensive hands-on workshops
- Networking with other participants
- Full focus on learning
Your Learning Path
Frequently asked questions
Who is the Advanced DAX in Power BI - Practical Workshop training for?
This training is designed for professionals looking to develop skills in advanced dax in power bi - practical workshop. Required level: advanced.
How long is the Advanced DAX in Power BI - Practical Workshop training?
The training lasts 2. Available in online or on-site format.
Will I receive a certificate?
Yes — every participant receives a completion certificate confirming acquired competencies. EITT holds ISO 9001 accreditation.
Can this training be conducted for a closed group?
Yes — we offer dedicated closed trainings for companies. We customize the program to your team's needs. Contact us for an individual quote.
Request a quote
Funding Options
Check funding options for your company
Development Services Database
Up to 80% funding for SMEs from EU funds
Check availabilityNational Training Fund
Up to 100% funding for employers
Learn moreTrusted by
We train teams at Poland's largest companies
Interested in this training?
Contact us - we'll prepare an offer tailored to your organization's needs.