Power BI DAX Training CoursesFace to face / Online public schedule & onsite training. Restaurant lunch included at STL venues.
From £460 List price £700
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.
Attended our 2 day Power BI Modelling, Visualisation and Publishing course, or Power Bi users with a basic understanding of DAX.
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
Arguably, the most experienced and highest motivated trainers.
Training is held in our modern, comfortable, air-conditioned suites.
Modern-spec IT, fully networked with internet access
A hot lunch is provided at local restaurants near our venues:
Courses start at 9:30am.
Please aim to be with us for 9:15am.
Browse the sample menus and view joining information (how to get to our venues).
Available throughout the day:
Regular breaks throughout the day.
Contains unit objectives, exercises and space to write notes
Available online. 100+ pages with step-by-step instructions
Your questions answered on our support forum.
|
|
A&A Electrical Ltd
Luis Fernandes Joao,
Operations Director
Excellent knowledge and good insight information
Power BI DAX
Business West Ltd
Caroline Dance,
CRM Data Analyst
The course was fine for who it was aimed at it and the information provided to run alongside the course will be very useful in future.
Power BI DAX
Now Training
Ravi Kandrra,
Cognos Developer
Course was well structured and Covered a lot.
Power BI DAX
This course is perfect for business analysts, data professionals, and managers aiming to improve their reporting and analytical skills. Attendees will benefit from learning advanced DAX course techniques, DAX Power BI courses London, and practical applications relevant to their roles.
You'll gain hands-on experience with DAX formulas, data modelling, and troubleshooting within Power BI. The training covers topics such as DAX courses, DAX training Power BI courses, and advanced DAX training, helping you streamline your workflow and unlock deeper insights.
Our DAX training Power BI sessions are instructor-led and highly interactive, available both in-person at our London venues and online. You'll work through real-world scenarios, network with peers, and receive expert guidance tailored to your needs. Learning DAX for Power BI is made practical and engaging.
Yes, every participant is awarded a certificate of achievement, which is recognised by employers and can be added to your professional development record. Completing DAX courses and Power BI DAX training demonstrates your commitment to continuous improvement.
Certainly. We offer on-site training throughout the UK, customising the DAX course content to suit your organisation's requirements. This ensures your team gets the most relevant and practical learning experience, whether it's advanced DAX training or Power BI and DAX training.
STL guarantees no course cancellations, offers a comprehensive public schedule, and provides post-course support for 24 months. Our expert trainers have extensive industry experience, and our venues feature premium facilities. Corporate clients benefit from volume discounts, bespoke training, and dedicated account management. We also offer Power BI DAX online training.
Both our face-to-face and online trainings are one-day courses focused on practical skills. You'll cover DAX fundamentals, formula writing, variables, debugging, time intelligence, and advanced modelling. You'll start to get to grips with DAX language training. The curriculum is designed to ensure you can apply Power BI DAX training and advanced DAX course techniques immediately in your work.
| Next date | Location | Price |
|---|---|---|
| Fri 10 Jul | Bloomsbury | £495 |
| Thu 13 Aug | Online | £495 |
| Mon 17 Aug | Bloomsbury | £495 |
| Wed 23 Sep | Bloomsbury | £473 |
| Mon 5 Oct | Online | £464 |
| Fri 30 Oct | Bloomsbury | £450 |
And 16 more dates...
Loading content...
Excellent
Agility Alliance
Business Performance Analyst
Tola
STL you rock
"My experience with STL was fantastic the whole PBI Dax training was indeed incredible and informative well explanatory. I will highly recommend STL anytime any day anywhere thank you STL you rock"
Tutorials and discussions on MS Office
MS Office tips to save you time
MS Office shortcut keys for all versions
Handy info on industry trends
Latest news & offers
Loading content...
Below are some extracts from our Power BI DAX manual.
What is DAX?
DAX (Data Analysis Expressions) is a formula language used
in Power BI, Analysis Services, and Power Pivot in Excel.
It allows you to create custom calculations, aggregations,
and transformations for data analysis.
Why Is DAX Important?
While basic reports can be created without DAX, more
complex scenarios require it. DAX empowers you to solve
real business problems and gain insights from data.
Three Fundamental Concepts:
Syntax: Understand how DAX formulas are written.
Functions: Explore the extensive library of DAX functions.
Context: Learn how DAX evaluates expressions within
specific contexts.
Column Calculations
Definition: These are calculations that create new columns in your data model.
Context: They are calculated row by row during data load and stored in the data model.
Usage: Useful for calculations that need to be performed on each row of data, such as adding a new column that
calculates the total price by multiplying quantity and unit price.
Performance: Since they are stored in the data model, they can increase the size of your dataset.
DAX Measures
Definition: These are calculations that create new values based on aggregations or other calculations.
Context: They are calculated on the fly when you interact with your report, such as when you filter or slice data.
Usage: Ideal for dynamic calculations like sums, averages, or other aggregations that change based on user interactions.
Performance: They do not increase the size of your dataset since they are not stored but calculated as needed.
Key Differences
Storage: Column calculations are stored in the data model, while DAX Measures are not.
Calculation Time: Column calculations are done during data load, whereas DAX Measures are calculated during report
interaction.
Use Cases: Use column calculations for row-level operations and DAX Measures for aggregations and dynamic calculations.
DAX Studio is a powerful tool for anyone working with Power BI,
Analysis Services, or Power Pivot.
Performance Optimization
DAX Studio helps you analyze and optimize the performance of your
DAX queries. It includes tools like the VertiPaq Analyzer to
understand memory usage and Server Timings to see how long
your queries take to execute.
Advanced Querying
With DAX Studio, you can write, execute, and debug complex DAX
queries more efficiently. The IntelliSense feature provides
auto-completion and syntax highlighting, making it easier to write
accurate queries.
Learning and Documentation
DAX Studio is a great learning tool. It helps you understand the DAX
language better by allowing you to experiment with different queries
and see immediate results.
TrustScore
4.9
/ 5
2456 reviews
Call for assistance
We will call you back
Formerly Best Training
© 2026 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
Software Training London Ltd. t/a STL
2nd Floor, CA House, 1 Northey Street,
Limehouse Basin, London, E14 8BT, United Kingdom.
Registered in England and Wales.
