- 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.
- 2 days
- Virtual or on-site
- 15 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
- 26Nov
26 Nov 2026
Thursday
- Virtual
- 2 day
£825per person + VAT10% off 2 or more seats
- 17Dec
17 Dec 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 really tailored the course to our needs, encouraged us to ask questions, and was knowledgeable and really helpful.
The trainer was very patient and did not mind having to explain things a few times to make sure we were all on the same page, was very helpful for someone like myself who sometimes misses details on the first go around
Excellent trainer, the format of the training was fantastic and I got a lot from the course.
This was, by far, one of the best training courses I have had the pleasure of attending. The trainer was extremely knowledgeable and delivered a great course!
This was the first time I have joined an excel course and I found it very informative and very helpful.
I liked how the trainer tailored the training around what our needs and roles are.
A great pace for somebody just starting and never an issue with questions, and always had a good way of answering.
From knowing nothing to what I know now and in less than a day I would highly recommend as it was extremely useful, and has made my understanding of MP a 100x better. Thank you the trainer for the great lesson!
Excellent course, definitely the best 'power' course I have attended. The trainer was enthusiastic about the material and kept it relevant to our needs
The trainer was really knowledgeable and extremely helpful in helping us to build our own reports.
It was very productive as a working session. I learnt a lot.
His careful delivery of the course really made the difference not only in its usefulness but in how well we, as learners, will retain and apply this new information.
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.
