Professional Training
4.9 (46 Reviews)

Power BI DAX

STL, In London (+21 locations)
Length
1 day
Price
0 GBP excl. VAT
Next course start
12 April, 2024 (+44 start dates)
Course delivery
Classroom, Virtual Classroom
Length
1 day
Price
0 GBP excl. VAT
Next course start
12 April, 2024 (+44 start dates)
Course delivery
Classroom, Virtual Classroom
Leave your details so the provider can get in touch

Power BI DAX

STL courses


  • 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.

What to expect

  • Courses never cancelled .
  • Restaurant lunch .
  • Last minute rescheduling .
  • 24 month delegate support forum .
  • And more... .

Upcoming start dates

Choose between 44 start dates

12 April, 2024

  • Classroom
  • London
  • English

23 April, 2024

  • Virtual Classroom
  • Online
  • English

21 May, 2024

  • Classroom
  • London
  • English

12 June, 2024

  • Virtual Classroom
  • Online
  • English

27 June, 2024

  • Classroom
  • London
  • English

1 August, 2024

  • Classroom
  • London
  • English

5 August, 2024

  • Virtual Classroom
  • Online
  • English

10 September, 2024

  • Classroom
  • London
  • English

26 September, 2024

  • Virtual Classroom
  • Online
  • English

16 October, 2024

  • Classroom
  • London
  • English

18 November, 2024

  • Virtual Classroom
  • Online
  • English

27 November, 2024

  • Classroom
  • London
  • English

2 January, 2025

  • Classroom
  • London
  • English

9 January, 2025

  • Virtual Classroom
  • Online
  • English

7 February, 2025

  • Classroom
  • London
  • English

3 March, 2025

  • Virtual Classroom
  • Online
  • English

14 March, 2025

  • Classroom
  • London
  • English

23 April, 2025

  • Classroom
  • London
  • English

29 April, 2025

  • Virtual Classroom
  • Online
  • English

30 May, 2025

  • Classroom
  • London
  • English

20 June, 2025

  • Virtual Classroom
  • Online
  • English

Enquire for more information

  • Classroom
  • Aberdeen
  • English

Enquire for more information

  • Classroom
  • Bedford
  • English

Enquire for more information

  • Classroom
  • Belfast
  • English

Enquire for more information

  • Classroom
  • Birmingham
  • English

Enquire for more information

  • Classroom
  • Bristol
  • English

Enquire for more information

  • Classroom
  • Burnley
  • English

Enquire for more information

  • Classroom
  • Cardiff
  • English

Enquire for more information

  • Classroom
  • Edinburgh
  • English

Enquire for more information

  • Classroom
  • Edinburgh
  • English

Enquire for more information

  • Classroom
  • Glasgow
  • English

Enquire for more information

  • Classroom
  • Leeds
  • English

Enquire for more information

  • Classroom
  • Leicester
  • English

Enquire for more information

  • Classroom
  • Liverpool
  • English

Enquire for more information

  • Classroom
  • London
  • English

Enquire for more information

  • Classroom
  • Manchester
  • English

Enquire for more information

  • Classroom
  • Newport
  • English

Enquire for more information

  • Classroom
  • Nottingham
  • English

Enquire for more information

  • Classroom
  • Portsmouth
  • English

Enquire for more information

  • Classroom
  • Sheffield
  • English

Enquire for more information

  • Classroom
  • Southampton
  • English

Enquire for more information

  • Classroom
  • Sunderland
  • English

Enquire for more information

  • Classroom
  • Wolverhampton
  • English

Enquire for more information

  • Virtual Classroom
  • Online
  • English

Suitability - Who should attend?



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.

Training Course Content



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

Expenses



List price £700, promotional rates available. STL are the only company to offer a dynamic pricing and availability model, updated live on our site, daily on this portal. Closed group training options available (at your offices, UK wide/International or our London Venues). Contact us below.

Request information - obligation free

Contact course provider

Fill out your details to find out more about Power BI DAX.

  Contact the provider

  Get more information

  Register your interest

Country *

reCAPTCHA logo This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Customer Outreach Award

customer-outreach-badge-2019

We believe that it should be easy for you to find and compare training courses. 

Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.

Reviews by course attendees

Average rating 4.9

Based on 46 reviews.
Write a review!
5/5
Rachael
29 Jun 2023

Jens is great. I enjoyed the course and will definitely recommend to my colleagues

5/5
Ian
29 Jun 2023

Most useful topic: understanding variables

5/5
Nicola
29 Jun 2023

there is nothing - it was brilliant!

STL
1 Northey Street, 2nd Floor, CA House
E14 8BT London

STL

Helping businesses improve performance with proven learning and development solutions. London-based with a global reach. STL seek to provide an unrivalled value and quality service, enabled by our strong working culture. Our 500+ courses deliver learning solutions across leadership and...

Read more and show all courses with this provider

Ads