Power BI - Dax training course

• Gain an Introduction to Commonly Used DAX Functions
• Utilise Dax as a query language in Dax Studio
• Capture and debug queries with Dax Studio
• Understand how to use variables, calculations and cumulative totals
• Utilise DAX studio to debug and increase performance
• Apply Sum, Average, Count and DistinctCount
• Learn to Create a measure table
• Acquire skill in Copying and Moving Measures
• Use Variables in calculation
• Explore Different granularity: calculate allocated weight
• 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
• IF, HasOneValue
• Use a Safe Divide Function and the Blank() Function

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 in order to create complex calculations which will allow you flexibility beyond that offered by the standard toolset.

Learn how to use variables, create write time intelligence calculations, cumulative totals, dynamic titles, DAX studio to debug and increase performance  ​​​

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