Power BI - Dax training course

• Gain an introduction to commonly used DAX functions
• Apply Sum, Average, Count and DistinctCount
• Learn to create a measure table
• Understand how to use Variables, Calculations and Cumulative Totals
• Acquire skill in Copying and Moving Measures
• Use Variables in Calculation
• Explore Different granularity: calculate allocated weight
• Use Dax as a query language in Dax Studio
• Capture and debug queries with Dax Studio
• Use DAX studio to increase performance
• Evaluate Contexts and Relationships
• Understand the use of CALCULATE
• Learn Table Functions: ALL, ALLEXCEPT, FILTER, DISTINCT, VALUES
• Explore Advanced Evaluation Context DAX
• Roll totals for different periods
• Learn IF, HasOneValue
• Use a Safe Divide Function and the Blank() Function
• introducing DAX calculation groups to enhance measures flexibility and re-usability

"Great coverage of DAX principles including basic DAX formulae and  time intelligence. The trainer was very knowledgeable and informative."

AW Senior BI developer

Our Dax training course is aimed at Power BI users who are looking to get even more out of this popular tool.

We will show you how to use Power BI's functionality to create complex calculations that will allow you flexibility beyond that offered by the standard toolset.

Learn about Variables, Time Intelligence calculations, cumulative totals and dynamic titles, and how to use DAX Studio to debug and increase performance.   ​​​

A number of optional topics exist which can be requested for private courses, depending on your organisation's business requirements.