Power BI Course
Power Query, data modeling, DAX, visuals, dashboards and Power BI Service - from first import to a published report.
View course →
DAX training
Power BI DAX Course
Understand how DAX actually evaluates, so you can write measures that stay correct when a user changes a filter.
- Hands-on, project-based
- Trainer feedback on every module
- Free counselling & demo on request
- Format
- Live, instructor-led
- Duration
- Shared at counselling
- Fees
- Shared on enquiry
- Level
- Intermediate
Power BI DAX Course overview
DAX looks like Excel formulas but behaves differently: a measure is evaluated in the filter context of each cell in a visual. Most DAX frustration comes from not seeing that context.
This course teaches context first, then the functions that change it. You practise on a sales model so every example answers a real question: revenue last year, share of total, top-N customers.
Who this course is for
- Power BI users who copy DAX formulas without understanding them
- Analysts who build models for others
- Excel Power Pivot users moving to Power BI
Prerequisites
- Basic Power BI and a simple star-schema model (Power BI course level)
DAX topics
Measures vs calculated columns
When each is evaluated, how they affect model size and why most business logic belongs in measures.
Filter context and row context
How slicers, rows and relationships shape a result, and how context transition works.
CALCULATE, FILTER, ALL
Modify filters to compute totals, percent of total and comparisons.
SUMX, COUNTX and iterators
Row-by-row calculations such as revenue = quantity × price.
RELATED and relationships
Fetch values across tables and understand USERELATIONSHIP.
Time intelligence
TOTALYTD, SAMEPERIODLASTYEAR, DATEADD and rolling periods.
What you will learn
- Explain filter and row context in plain words
- Write reliable measures for totals, ratios and rankings
- Use CALCULATE to change filters deliberately
- Build year-to-date and prior-period comparisons
- Debug a measure that gives the wrong number
- Use variables for readable, faster DAX
Tools covered
- Power BI Desktop
- DAX
- DAX Studio (intro)
- Performance Analyzer
Practical projects
KPI measure library. A documented set of 20 reusable measures.
Time intelligence pack. YTD, MTD, YoY and rolling 12 months.
Customer ranking. Top-N and percent-of-total views with dynamic titles.
Detailed curriculum
The program is taught module by module. Each module ends with a hands-on exercise built on business-style data.
Module 1DAX fundamentals
- Syntax, data types, operators
- Measures vs columns
Module 2Evaluation context
- Filter context, row context
- Context transition
Module 3CALCULATE in depth
- Filter arguments, ALL, ALLEXCEPT, REMOVEFILTERS
- KEEPFILTERS basics
Module 4Iterators and aggregation
- SUMX, AVERAGEX, COUNTX, RANKX
Module 5Relationships in DAX
- RELATED, RELATEDTABLE, USERELATIONSHIP
Module 6Time intelligence
- Date table requirements
- YTD, YoY, rolling windows
Module 7Variables, debugging and performance
- VAR/RETURN
- Common errors and fixes
Module 8Advanced DAX patterns
- Dynamic segmentation, what-if, basket analysis intro
Learning methodology
Every concept is taught on a working file. You see the business question first - for example, "which regions missed target last quarter?" - and then build the formula, query or measure that answers it.
Each module closes with an exercise you complete yourself, followed by trainer feedback. Mistakes are part of the process: we cover the errors people actually hit, such as text-formatted numbers, broken lookups and wrong relationship direction.
Training files and practice datasets are provided so you can repeat every exercise after class.
Training format, batches and certification
Format. Instructor-led, practical sessions. Online, classroom and hybrid options are confirmed when you speak to us.
Batches. Upcoming batch dates are shared during counselling so you get current information. Ask for weekday, weekend or fast-track availability.
Certification. You receive a CharterPeak course completion certificate on completing the program and its assessments. This is not a Microsoft certification. If you want to prepare for a Microsoft exam such as PL-300, tell us and we will map the syllabus to the official skills outline.
Your trainers
Trainer names, backgrounds and areas taught are listed on our trainers page. Ask for a short demo class or a call with the trainer before you enrol.
Sample lesson: why % of total shows 100% on every row
A new learner writes DIVIDE([Revenue], SUM(Sales[Amount])) and gets 100% in every row of a matrix. We trace why - each row’s filter context also filters the denominator - and fix it with CALCULATE([Revenue], ALL(Product[Category])) so the denominator ignores the row filter.
Career applications
- Power BI developer and BI analyst roles
- Finance and FP&A reporting
- Analytics engineering fundamentals
Continue your learning path
- Check your model design in Power BI data modeling
- Apply measures in dashboards
- See the overall Power BI course
Frequently asked questions
Is DAX hard to learn?
The syntax is small; the difficulty is thinking in filter context. We teach context with small visual examples before moving to complex measures.
Is DAX like Excel formulas?
It borrows many function names but works on columns and tables with filter context, so habits from cell formulas can mislead.
Do I need the full Power BI course first?
You need to be able to load data and build a basic model. If not, take the Power BI course first.
Does it help with Power Pivot in Excel?
Yes. DAX in Power Pivot and Power BI is the same language.
What is the duration of the Power BI DAX Course?
Duration depends on the batch (weekday, weekend or fast-track). We confirm the schedule and total hours when you speak to us, so you get current information rather than a fixed number on a web page.
Who can join the Power BI DAX Course?
Students, graduates, working professionals and career changers. The prerequisites are listed on this page; if you are unsure, book a free counselling call and we will point you to the right starting course.
Is the training practical?
Yes. Each module is taught on working files with exercises you complete yourself, followed by trainer feedback and project work.
Is the training online or in a classroom?
Delivery options depend on the batch. Ask about current online, offline and hybrid availability when you enquire.
Is certification provided?
You receive a CharterPeak completion certificate after finishing the program and its assessments. It is not a Microsoft certification and we do not promise exam results.
What fees and payment options apply?
Fees depend on the batch and format and are shared on enquiry. See our refund policy before you enrol.
Related courses
Power BI Data Modeling Course
Star schema, fact and dimension tables, relationships and performance - the foundation of reliable Power BI reports.
View course →Power BI Dashboard Course
Design KPI, sales, finance, HR, marketing and operations dashboards that people actually use.
View course →Power BI Data Analytics Course
Project-driven analytics in Power BI: question, data, model, analysis and a stakeholder-ready story.
View course →Related learning resources
DAX in Power BI: Fundamentals and Essential Functions
Understand filter context, CALCULATE and time intelligence so your measures stay correct.
Read guide →Power BI Data Modeling: Star Schema and Relationships
Why a star schema works best in Power BI and how to set up relationships correctly.
Read guide →What Is Power BI? A Plain-English Introduction
A plain-English explanation of Power BI, its components and who uses it.
Read guide →Ready to start?
Talk to us about your background and goals. We will recommend the right batch and starting point - no pressure.