Want to Learn DAX?

Start learning DAX with examples you can follow in Power BI. The course introduces measures, calculated columns, table functions, evaluation contexts and CALCULATE, then explains how relationships and time intelligence affect your calculations. Download the demo files to repeat the examples. The concepts also apply to Power Pivot and Analysis Services.

Learn the basics of data modeling without needing previous experience. Power BI demos introduce star schemas, normalization and common modeling scenarios, showing how the right model can simplify DAX and improve performance. Download the slides and demo files to explore the examples yourself.

Learn to solve reporting problems by changing the data model. Examples and exercises grow in complexity, covering star schemas, multiple fact tables, dates and snapshots. The aim is to make your DAX calculations simpler, faster and more reliable. Follow the lessons at your own pace and practice with downloadable exercise files.

Learn how to shape data models for your reports in a three-day classroom course. Work through business examples that show how better modeling leads to simpler DAX, faster queries and easier maintenance. Practice on your own computer during labs and ask the instructor questions as you learn.

Learn to choose a data model that answers your business questions in Power BI and Excel. Real-world examples explain tables, relationships, star schemas and granularity, then cover multiple fact tables, dates, historical attributes, snapshots and currencies. The book is suitable both for newcomers and for modelers looking for practical ideas.

Study DAX from its foundations through calculations for advanced business scenarios. Learn how evaluation contexts, CALCULATE and table functions work, then explore user-defined functions, time intelligence, visual calculations and calculation groups. Download the demos and exercises to practice, and use the course discussion area to ask questions about the material.

Learn DAX with a SQLBI instructor in a three-day workshop. Topics include row and filter context, CALCULATE, table functions, user-defined functions, time intelligence and calculation groups. Apply the concepts in labs on your own computer, with opportunities to ask questions and discuss the material during class.

Build a deep understanding of DAX with Marco Russo and Alberto Ferrari. The third edition covers evaluation contexts, CALCULATE, iterators and advanced calculations, including user-defined functions, calendar-based time intelligence, visual calculations and calculation groups. It also explains how to write DAX queries for testing and troubleshooting. This book provides the foundation for the Mastering DAX video course.

Understand the Tabular models behind Power BI and Analysis Services, including their features, limitations and development tools such as Tabular Editor. Learn about model types and how to build enterprise solutions. The full course also covers security, partitions, refresh and deployment, with modules you can revisit when working on a specific part of a model.

Put the foundations into practice with a small model of your own. Organize the data into a star schema, define the relationships and write simple measures. Check the results as you filter the report, and make sure you can explain how the model and the calculations work together.

Apply what you have learned to a more demanding business problem. Build the model, write the calculations and check the results against known examples. Use this step to identify what you still find difficult before exploring the patterns and performance techniques that follow.

Find and fix performance bottlenecks in DAX queries, measures and models using Performance Analyzer and DAX Studio. Study the formula engine, VertiPaq, DirectQuery over SQL and composite models, then learn when to change a formula or the model itself. The course assumes a good working knowledge of DAX and includes demo files and the Optimizing DAX book in PDF format.

Learn to diagnose slow DAX calculations in a two-day workshop at your company. Use Profiler and DAX Studio to measure performance, read query plans and improve formulas, relationships and large models. Practice in labs on your own computer. The workshop can be extended to work on your company's data and existing models.

Learn reusable DAX solutions through video explanations by Alberto Ferrari and Marco Russo. Each pattern shows how the calculations work and how to adapt them to your requirements. Choose the patterns relevant to your work, including time calculations, currency conversion, budgets, ranking and customer analysis, or study the complete collection.

Study a collection of reusable DAX solutions with working code and downloadable examples for Power BI and Excel. The second edition gives particular attention to time calculations and new and returning customers, alongside patterns for totals, ranking, budgets and currencies. The written patterns are also available on daxpatterns.com.

Browse reusable DAX solutions for common business questions in Power BI and Excel. Find patterns for time calculations, running totals, rankings, currency conversion, customer analysis and more. Read the written explanations online and use the sample models to understand how each solution works before adapting it to your data.

Explore specialized DAX, Power BI and Analysis Services topics through courses, white papers and individual video sessions by Alberto Ferrari and Marco Russo. SQLBI+ is a separate subscription for experienced model authors; it does not include Mastering DAX, Data Modeling or the standalone video courses.

Discover new techniques and keep your DAX knowledge up to date with our free resources:

Learn how to connect an AI assistant to your Power BI models and reports. Understand the roles of agents, skills, plugins and MCP servers, and how they work together. This introduction helps you move from copying code out of a chat to working with an agent connected to your model.

Learn the DAX you need to understand the measures an AI agent creates. Practice making clear requests, reading the generated code and checking whether the results answer your question. Build the knowledge to review calculations, even if you are not yet writing DAX yourself.

Apply DAX and AI to more complex business problems. Learn to guide an agent through scenarios that require both calculations and changes to the semantic model, then validate the solution. Work through the course or revisit the scenarios and concepts that are relevant to your own projects.