Power BI DAX Training CoursesFace to face / Online public schedule & onsite training. Restaurant lunch included at STL venues.
From £459 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.
|
|
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
Arup
Helen Dines,
Supervisor
Jens is very knowledgeable and enthusiastic, the course was great and ran at the right speed and covered everything would have wanted it to
Power BI DAX
Stockport Homes Ltd
Michael Thompson,
BI
Everything was good
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, Power BI DAX 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.
This is a one-day course focused on practical skills. You'll cover DAX fundamentals, formula writing, variables, debugging, time intelligence, and advanced modelling. 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 |
|---|---|---|
| Mon 9 Mar | Online | £459 |
| Fri 20 Mar | Bloomsbury | £485 |
| Mon 27 Apr | Bloomsbury | £495 |
| Fri 1 May | Online | £495 |
| Wed 3 Jun | Bloomsbury | £495 |
| Mon 22 Jun | Online | £483 |
And 18 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.
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.
In Power BI, Column calculations and DAX Measures are both used to create new data, but they serve different purposes and are used in different 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.
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.
DAX Examples
Calculating Total Sales: Suppose you have a table with a column named “SalesAmount.” To calculate the total sales, use the following DAX measure:
Total Sales = SUM('Sales'[SalesAmount])
Year-to-Date (YTD) Sales:
YTD Sales = TOTALYTD(SUM('Sales'[SalesAmount]), 'Date'[Date])
Top N Products by Sales:
Top N Products = TOPN(10, 'Products', [Total Sales])
Moving Average:
MAvg Sales = AVERAGEX(FILTER('Sales', 'Sales'[Date] <= MAX('Sales'[Date])), 'Sales'[SalesAmount])
Year-Over-Year Growth:
YoY Growth = DIVIDE([Total Sales], [Total Sales LY]) - 1
Creating a DATE table in Power BI using DAX is a great way to enable time intelligence functions in your reports.
DateTable = ADDCOLUMNS (
CALENDAR (DATE(2020, 1, 1), DATE(2024, 12, 31)),
'Year', YEAR([Date]),
'Month Number', MONTH([Date]),
'Month Name', FORMAT([Date], 'MMMM'),
'Quarter', 'Q' & QUARTER([Date]),
'Weekday', FORMAT([Date], 'dddd')
)
The CALCULATE function in Power BI is incredibly versatile and powerful for modifying filter contexts in your DAX expressions.
Example 1: Total Sales for a Specific Region
Total Sales UK =
CALCULATE(
SUM(Sales[SalesAmount]),
Sales[Region] = 'United Kingdom'
)
Example 2: Sales Last Year
Sales Last Year =
CALCULATE(
[Total Sales],
SAMEPERIODLASTYEAR('Date'[Date])
)
Example 3: Sales Excluding Specific Products
Sales Excluding Accessories =
CALCULATE(
[Total Sales],
REMOVEFILTERS(Products[Category]),
Products[Category] <> 'Accessories'
)
Example 4: Running Total
Running Total Sales =
CALCULATE(
[Total Sales],
FILTER(
ALL('Date'),
' Date'[Date] <= MAX('Date'[Date])
)
)
Using variables in Power BI can make your DAX formulas more efficient, readable, and easier to debug.
Example 1: Year-over-Year Sales Growth
Sales YoY Growth % =
VAR SalesPriorYear = CALCULATE([Sales], PARALLELPERIOD('Date'[Date], -12, MONTH))
RETURN DIVIDE(([Sales] - SalesPriorYear), SalesPriorYear)
Example 2: Average Sales per Transaction
Average Sales per Transaction =
VAR TotalSales = SUM(Sales[Amount])
VAR NumberOfSales = COUNTROWS(Sales)
RETURN TotalSales / NumberOfSales
Example 3: Discounted Sales
Discounted_Sales =
VAR DiscountedSales = SUM(FactInternetSales[SalesAmount]) - SUM(FactInternetSales[DiscountAmount])
RETURN DiscountedSales
DAX Studio is a powerful tool for anyone working with Power BI, Analysis Services, or Power Pivot.
Example : Year-over-Year Sales Growth
This example calculates the year-over-year (YoY) sales growth.
Sales YoY Growth % =
VAR SalesPriorYear = CALCULATE([Sales], PARALLELPERIOD('Date'[Date], -12, MONTH))
RETURN DIVIDE(([Sales] - SalesPriorYear), SalesPriorYear)
In this formula, SalesPriorYear is a variable that stores the sales from the same period last year. This variable is then used in the RETURN statement to calculate the YoY growth1.
TrustScore
4.9
/ 5
2427 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.
