CUSTOMISED
Expert-led training for your team

Dismiss

Power BI - Dax training course

Name: DAX Training Course
Start: 2025-10-24 00:00
End: 2025-10-25 00:00
Location: Power BI - Dax training course

Maximise Power BI's features to create complex Calculations in DAX - the formula language used throughout Power BI

"Great coverage of DAX principles including basic DAX formulae and time intelligence. The trainer was very knowledgeable and informative."

AW, Senior BI developer, Power BI - DAX, March 2021

Public Courses

26/02/25 - 1 days

£795 +VAT

Enrol

09/04/25 - 1 days

£795 +VAT

Enrol

21/05/25 - 1 days

£795 +VAT

Enrol

Customised Courses

* Train a team
* Tailor content
* Flex dates

From £1200 / day

Highlights Details Audience Feedback Prices/Dates Related Courses

Public Courses

Highlights

Gain an introduction to commonly used DAX functions
Apply SUM, AVERAGE, COUNT and DISTINCTCOUNT
Housekeeping with Measure Groups
Using variables in calculations
Integrate tables of different granularity
Develop DAX queries in DAX Studio
Capture query traffic
Solve DAX performance problems
Understand the use of CALCULATE
Learn Table Functions: ALL, ALLEXCEPT, FILTER, VALUES
Evaluation contexts and relationships
Explore Advanced Evaluation Context DAX
Rollup totals for different periods
Apply IF, SELECTEDVALUE
Use a Safe Divide Function and the Blank() Function
Introducing DAX calculation groups to enhance measures flexibility and re-usability

Course Details

DAX

Examples with SUM, AVG, COUNT, DISTINCTCOUNT
Common DAX patterns
Scenarios for FILTER, SELECTEDVALUE
Ranking functions, TOPN
When to use the X-functions
Create filtered measures with CALCULATE
Virtual tables
Percents of Total with ALL, ALLSELECTED, ALLEXCEPT

BEST PRACTICES

Safe DIVIDE
Housekeeping with measure groups
Interim measures
Measures for conditional formatting
Use of DAX variables
Using the BLANK() function

CONTEXT

Be clear on Measures vs Columns
Understand Filter Context
Propagate filter through Context Transition
Iterate with Row Context
Implement ABC Classification

RELATIONSHIPS

Filter flow direction through relationships
RELATED vs LOOKUPVALUE
Data tables vs lookup tables
Accommodating different table granularities
Data lineage

TIME INTELLIGENCE

Benefits of Dates table
Year-on-year comparisons
SAMEPERIODLASTYEAR, PARALLELPERIOD
Cumulative Total to Date calculations
Fiscal years/quarters
Special accounting periods
Pro-rata view for incomplete trading periods
Events in progress
Budget vs Actual comparison methodology

PRODUCTIVITY MISC

Understand IntelliSense syntax notation
Dynamic titles, CONCATENATEX
Introduction to DAX Studio
DAX query examples
Capture DAX query traffic
Identify and fix performance issues
Use Calculation Groups
What-if analysis
Design for budget and actual figures on same chart

Who should attend

Business Analysts, Financial Analysts, Quants, Data Scientists.

Staff who already use Power BI or who have attended our introduction course and who need to explore its features in more depth.

Developers and Super Users/ Power Users looking to get more out of Power BI.

Note : This course requires delegates to run Power BI Desktop. Mac users must make arrangements to use a PC

Feedback

4.8 out of 5 average

"Great coverage of DAX principles including basic DAX formulae and time intelligence. The trainer was very knowledgeable and informative."

AW, Senior BI developer, Power BI - DAX, March 2021

“JBI did a great job of customizing their syllabus to suit our business needs and also bringing our team up to speed on the current best practices. Our teams varied widely in terms of experience and the Instructor handled this particularly well - very impressive”

Brian F, Team Lead, RBS, Data Analysis Course, 20 April 2022

Top 20 "Pain Points" for Data Analysts

Problem 11 : You have a very complex Excel spreadsheet and you want to reproduce EXACTLY the same spreadsheet in Power BI
Solution: Power BI is not Excel, it works differently and it has different strengths. In order to tackle this issue the best way is going back to the source and try to...

All 20 points are in our latest Newsletter - Delivered directly to your inbox

More about this course

Our Dax training course is aimed at Power BI users who are looking to get even more out of this popular tool.

We will show you how to use Power BI's functionality to create complex calculations that will allow you flexibility beyond that offered by the standard toolset.

Learn about Variables, Time Intelligence calculations, cumulative totals and dynamic titles, and how to use DAX Studio to debug and increase performance.

A number of optional topics exist which can be requested for private courses, depending on your organisation's business requirements.