Introduction to DAX for Power BI

Course Overview

Course 1365 introduces Data Analysis Expressions (DAX) in Power BI. It provides an introduction to DAX and progresses through intermediate to an advanced level. The journey stats with an introductory discussion about DAX, the syntax of DAX statements, how to write structured DAX in the DAX editor. You also get an introduction to DAX Studio, a third party tool that can be used to write DAX. You can decide if you want to use DAX Studio for the course exercises. We will discuss many of the functions in DAX and how they could be used in a Power BI Project including explaining the use of iterator functions vs standard statistical functions. There are discussions explaining Calculated Columns, Tables and Measures discussing the differences. There is also an explanation about Quick Measures and how we can utilise those. We will explain DAX Context and where those contexts apply. There are separate discussions for the CALCULATE function, the usage of a Data Model and incorporating a Date Dimension and also on using Time Intelligence Functions. We will conclude with a discussion around utilising DAX with Row Level Security.

This course will be delivered over 2 full days.