- Courses
- Microsoft Power BI
- DAX Introduction
Microsoft DAX Introduction Training Courses
DAX Introduction
Gain practical skills in DAX for Power BI, Power Pivot, and SSAS Tabular models. This course focuses on the essentials, calculated columns, relationship functions, and time intelligence, enabling you to produce reliable business reports and smarter data models.
Not sure this is the right level? Compare all Microsoft Power BI training courses.
- 2 days
- Virtual or on-site
- 18 upcoming dates
Trusted by teams at
Course overview
This practical, hands-on course gives you a clear foundation in using DAX with Power BI, Power Pivot for Excel, and SSAS Tabular models. Over two structured days, you'll discover the essentials of building calculated columns, measures, and advanced data models using real business scenarios.
Training is delivered by experienced, business-focused instructors who guide you through DAX fundamentals, from basic aggregators to logical, filter, and time-intelligence functions. The sessions build your confidence to use DAX for reporting and analysis.
By the end of the course, delegates will be able to use DAX effectively in Power BI for creating relationship-aware calculations, robust metrics, and advanced reports. Both in-person and virtual training options ensure flexibility to suit your team.
Who it's for
- Business analysts using Power BI
- Excel power users moving into DAX
- Data professionals developing tabular models
What you need before you start
- Experience with Power BI
- Competence in using Microsoft Excel
What you'll learn
What you will be able to do by the end of the course.
- Write calculated columns and measures using core DAX functions
- Apply row, filter, and evaluation context in data models
- Construct time-intelligence measures for advanced analysis
- Develop calculations with CALCULATE, FILTER, and related functions
- Create relationship-aware formulas with RELATED and USERELATIONSHIP
- Troubleshoot DAX using variables and techniques in DAX Studio
Course outline
13 modules across 2 days.
1Introduction to DAX2 topics+
- What is DAX?
- Naming Requirements
2DAX Syntax3 topics+
- Data Types
- DAX Code Formatting
- Rules & Guidelines
3Basic DAX Functions4 topics+
- Basic Aggregators
- Basic Iterators
- COUNTROWS Function
- DISTINCTCOUNT Function
4Logical Functions5 topics+
- IF Function
- SWITCH Function
- AND Function
- OR Function
- IFERROR Function
5Filter Functions4 topics+
- Introduction Evaluation, Row & Filter contexts
- FILTER Function
- CALCULATETABLE Function
- CALCULATE Function
6Date & Time Functions13 topics+
- CALENDAR Function
- CALENDARAUTO() Function
- DATE Function
- DATEVALUE Function
- YEAR Function
- MONTH Function
- WEEKDAY Function
- WEEKNUM Function
- FORMAT Function
- EDATE Function
- NOW Function
- TODAY() Function
- DATEDIFF Function
7Information Functions6 topics+
- Information Functions Overview
- HASONEVALUE Function
- ISFILTERED Function
- ISINSCOPE Function
- USERNAME Function
- USERPRINCIPALNAME Function
8Relationship Functions3 topics+
- RELATED Function
- RELATEDTABLE Function
- USERELATIONSHIP Function
9Time-Intelligence Functions6 topics+
- SAMEPERIODLASTYEAR Function
- DATEADD Function
- LASTDATE Function
- DATESMTD/DATESQTD/DATESYTD Functions
- TOTALMTD, TOTALQTD, TOTALYTD Functions
- Other Time Intelligence Semi-Additive Measures
10Other Useful Functions7 topics+
- DIVIDE Function
- RANKX Function
- ALL Function
- ALLSELECTED Function
- VALUES Function
- SUMMARIZE Function
- DATATABLE Function
11Understand the Use of Parameter Tables2 topics+
- What-If Parameter
- What if Parameter in Use
12Creating Measures Using Variables+
13The DAX Studio Application Demonstration3 topics+
- What is DAX Studio
- Format DAX Calculations in DAX Studio
- Evaluate a Calculation in DAX Studio
Dates & booking
Pick a date and book online. Prices are per person and exclude VAT.
- 26Oct
26 Oct 2026
Monday
- Virtual
- 2 day
£825per person + VAT10% off 2 or more seats
- 26Oct
26 Oct 2026
Monday
- Virtual
- 2 day
£825per person + VAT10% off 2 or more seats
- 26Nov
26 Nov 2026
Thursday
- Virtual
- 2 day
£825per person + VAT10% off 2 or more seats
Booking 2 or more places?
Save 10% on every seat when you book them together, subject to availability. Choose a date above, then book up to 6 seats.
Choose a datePrivate Group Training
Run this course just for your team, virtually or at your site.
Booked with a 100% money-back guarantee
Every course we run is covered. Book with confidence — if it isn’t right, you aren’t left out of pocket.
Training for your team
Run this course just for your team, on a date that suits you, virtually or at your site.
- Tailored contentBuilt around your team's work and skill levels.
- Flexible schedulingDates and times that suit your team, not ours.
- Your place or onlineDelivered at your office or virtually.
- Better value per headOne trainer, one day, your whole team.
- A dedicated trainerYour team gets all of the trainer's attention.
- Relevant examplesExercises shaped around the work your team does.
Why Future Savvy
Practical training, backed properly
Rated 4.72/5
From 696 reviews by learners and clients.
Money-back guarantee
A 100% money-back guarantee, for peace of mind.
Up to six learners
Small enough that every delegate gets trainer time on their own work.
Trainers who do the job
Practitioners who use these tools on real work, not career instructors.
Support after the course
Email your trainer when you hit something back at your desk.
What delegates say
Independently verified reviews, alongside quotes collected from delegates after their course.
I had a good experience with this Microsoft Excel training course! Mark the trainer was exceptionally knowledgeable, patient, and engaging, taking the time to explain complex functions and formulas in a way that was easy to understand. The pace of the class was well-managed, and there was plenty of opportunity to ask questions without feeling rushed. I left the session feeling much more confident, efficient, and equipped with time-saving shortcuts. Highly recommended for anyone looking to upgrade their spreadsheet skills!
good value for money, I understood notions that were very not clear to me. Thanks to Mark.
Very good communication and an excellent tutor.
Very happy with Mark's training ethos and training he provided.
Excellent course and really well presented. Starting from basic knowledge the course guided you through step by step and was well paced for all.
Really enjoyed the course. Tutor was knowledgeable, friendly and gave real-world, practical advice to get the most out of the training.
The trainer was really friendly and positive, really clear, and made sure everyone was on the same page, and spent individual time focusing on each person to make sure they understood and were up to speed with the training.
Overall the course was excellent. The trainer delivered well, he was knowledgeable and concise.
Overall - Brilliant though, genuinely, the trainer was informative, talked at a steady pace
asdfasdf
here is my quote text
Verified reviews are published on our Reviews.io profile, where anyone can read every one of them.
Frequently asked questions
Who is this DAX Introduction course suitable for?+
This course is ideal for Power BI users, experienced Excel professionals moving into data modelling, and business analysts looking to develop DAX skills for creating more advanced reports and calculations.
What will I be able to do after completing this course?+
You will be able to write and troubleshoot core DAX measures, create and manage relationship-aware calculations, and use DAX to build more dynamic and robust business reports in Power BI or Excel.
Is there any required experience before taking this course?+
You should have experience with Power BI and be comfortable using Microsoft Excel. No prior DAX coding knowledge is needed—just a willingness to get stuck in and explore new concepts.
Is this training delivered in-person or online?+
We offer the course both in-person and virtually. You can choose the format that best suits you or your team.
Will I get hands-on practice with DAX during the course?+
Absolutely. The course uses real business scenarios, exercises, and labs, so you can practise writing DAX calculations as you learn—no passive PowerPoint overload.
Which tools does the course use for teaching DAX?+
The course covers DAX in Power BI including practical exercises where suitable.
What support is available after the training?+
After completing the course, you have access to follow-up support and resources aimed at helping you embed what you’ve learned back at work.
Training where your team works
Microsoft Power BI training by location
See local delivery details, nearby course options and practical information for your area.
