Power BI DAX

by STL Claim Listing

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.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

STL Logo

img Duration

Enquire Now

Course Details

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

  • Kent Branch

    Hoo Marina, Vicarage Lane, Kent

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy