Power BI DAX

Who Is This Course For?

This one day course is ideal for experienced users of Power BI who wish to optimise the speed and efficiency of Power BI through the use of DAX (Data Analysis Expressions) formula language.

Prerequisites

Attended our 2 day Power BI Modelling, Visualisation and Publishing course, or Power Bi users with a basic understanding of DAX.

Benefits

At the end of this course you will have a greater understanding of building DAX functions. You will understand how you can optimise the speed of your measures in your data model and the use of variables to optimise and debug the DAX measures.

Course Syllabus

• Introduction to DAX

  • What is DAX (Data Analysis eXpressions)

  • Why do we need DAX in Power Bi Desktop

  • The DAX Structure

  • The DAX Formatter

  • Column Calculations versus Measures

• Basic DAX functions

  • SUM/SUMX

  • COUNT/COUNTX/DISTINCTCOUNT/COUNTROWS

  • AVERAGE/AVERAGEX

  • MAX/MAXX

  • MIN/MINX

• Logical functions

  • IF

  • SWITCH

  • AND/OR

• Filter functions

  • Calculate

  • Related

  • Relatedtable

  • Filter

  • Hasonevalue

  • Values

  • All

  • Userelationship

  • Isfiltered

• Time-intelligence functions

  • Dateadd

  • Sameperiodlastyear

  • Eomonth

  • Datesbetween

  • Totalmtd/totalqtd/totalytd

  • Datesmtd/datesqtd/datesytd

  • Previousday/ Previousmonth/ Previousquarter/ PreviousyeaR

• Other useful functions

  • Lookupvalue

  • Earlier

  • Combinevalues

  • Summarize

  • Rollup

  • Divide

  • Topn

  • Firstdate

  • Lastdate

• Understand the use of parameter tables

• What is a parameter table

• How to use a parameter table in DAX

• The DAX Studio Application Demonstration

• Benefits of writing DAX and testing DAX in DAX Studio

• Variables

• What is a variable and what is the benefit using variables

• Debug code

• Introduction to calculated tables in Power BI Desktop

  • What is calculated tables

  • Create Calendar table

  • The UNION function