Learn how to use AI assistants to generate DAX calculations and validate their correctness. Starting from business requirements, you learn how to guide AI, read the generated code, identify errors, and verify results using practical examples. The course introduces the DAX concepts needed to evaluate AI-generated calculations, without requiring you to write every expression yourself. For Power BI users new to DAX and experienced developers who want to use AI effectively.
The goal of this two-day classroom course is to learn how to write effective DAX with an AI assistant and to review the code it produces. The focus is on ensuring that business requirements are correctly implemented in DAX expressions by inspecting the code and creating appropriate tests for different reports using the same metrics.
The topics follow the order you would use to learn DAX anyway, from the first measures and calculated columns to filter context and CALCULATE, variables, time-related calculations, hierarchies and ranking, calculation groups, and user-defined functions.
The classroom course prioritizes interaction with students. The course includes access to DAX with AI video courses, which provide additional material to reinforce learning after class.
The classroom course includes practical assignments: you will apply the concepts using your own laptop.
Topics
- Measures vs calculated columns
- Filter context and CALCULATE
- Variables and tables
- Time-related calculations
- Hierarchies and ranking
- Dynamic calculations
- Calculation groups and disconnected paramenters
- User-defined functions
The outline may be adjusted on customer request.