DAX
Welcome, champion! 🔥
You've mastered 0 of 86 lessons. Start your first lesson free — no signup needed.
About this course
A DAX formula can be one line long and still return a number that looks right in one cell of a visual and wrong in the total. This online DAX course on Abekus teaches the ideas that explain why: filter context, row context and context transition, CALCULATE and its modifiers, iterators and table functions, variables, time intelligence, window functions, DAX queries and performance, in short reading-card lessons each followed by an MCQ quiz.
Who this DAX course is for
It is written for Power BI and Excel analysts who can already build a basic report and now need measures that are correct. It does not teach report building. The course starts with one measure, Total Sales = SUM(Sales[Amount]), and checks its result with an EVALUATE query before anything else is added. By the end you can reason about filter and row context, use CALCULATE and its modifiers deliberately, write iterator, time-intelligence and window-function measures, and spot formulas that are slow or wrong.
Every example uses one small sales model: a Power BI semantic model in Import mode with a star schema of a Sales fact table and Date, Product, Customer and Store tables. Measures are written in formula form, as Measure Name = expression, and queries as EVALUATE text of the kind run in DAX query view, so no lesson depends on a screenshot. Classic time intelligence on a marked Date table is the default; calendar-based time intelligence, a preview feature, has its own subtopic. The course leaves out Power Query and M, report design, visual formatting, service administration, row-level security setup screens, Excel Power Pivot specifics and MDX, and it mentions DirectQuery and composite models only once.
How the lessons work
Each lesson is a short set of reading cards on one function or idea, usually with a formula of a few lines and the result it returns on the sales model, followed by a quiz of multiple-choice questions that often ask what a measure will return in a given cell. Lessons go from basics up: first measures and the data model, then evaluation contexts, CALCULATE and its filter modifiers, iterators and table functions, variables, logic and errors, time intelligence, advanced patterns such as window functions and calculation groups, then DAX queries and performance, and finally comparisons and worked cases. You move at your own pace.
MCQ practice vs video courses for DAX
Video courses on Udemy, Coursera or Microsoft Learn are a good choice if you want to watch someone build a report and its measures in Power BI Desktop. This course is built for a different job: a short explanation followed straight away by questions about real formulas, such as what a measure returns in the total row, whether a boolean filter in CALCULATE replaces or keeps the existing filter, what SUM returns inside a calculated column, or whether a variable changes inside a later CALCULATE. DAX behaviour is precise, and predicting it question by question builds the mental model that reading formulas alone does not. Many analysts use both: a video to see the tool, and questions to understand the contexts.
Common DAX mistakes
The course corrects these directly:
- Expecting a calculated column to respond to slicers. It is computed at refresh; only measures respond to filters.
- Assuming SUM and SUMX always give the same result. SUMX evaluates an expression for each row, such as quantity times price, and then adds the results.
- Thinking ALLSELECTED removes every filter. It keeps outer filters such as slicers.
- Running time intelligence on any date column, gaps included. The classic functions need a contiguous date table.
- Expecting a variable to be re-evaluated inside a later CALCULATE. It is evaluated once, where it is defined.
- Treating visual calculations as model measures. They exist only on the visual.
- Dividing with the slash operator. DIVIDE returns BLANK, or an alternate result, when the denominator is zero.
Best way to learn DAX
Learn the evaluation contexts before the functions. For every measure, ask which filters are active in the cell and whether a row context exists, predict the number, then run it. Split long measures with VAR so each step can be checked. The last part of the course is built around the choices analysts face: visual calculations versus model measures, ALL versus REMOVEFILTERS versus ALLSELECTED, FILTER versus CALCULATETABLE, SUM versus SUMX, and when to use a calculated column, calculation groups or TREATAS, applied to sales versus target measures, a customer retention cohort measure, inventory days of cover and budget allocation across months.