How to learn DAX

Whether you are starting from scratch or have already learned the basics of DAX, this guide will show you all the steps to follow in order to master the Power BI and Analysis Services query language.

Select your background and follow the steps below to become a real DAX expert!

Are you a Power BI user?

Start here – you are a DAX Rookie.

1
free
Get an overview of all the features of Power BI.
2
free
Grasp the basics of the DAX query language.
3
Learn how to build data models properly in Tabular.
4
Consolidate your knowledge on data modeling.
5

Practice

Let's build Star Schemas and write simple formulas!
6
free trial
Learn how to master the DAX query language.

Congratulations, you've become a DAX Ninja!

7
Consolidate your knowledge of DAX.
8

Practice

Let's work with complex formulas!
9
free
A score higher than 75% is required to proceed to the next step.
10
free trial
Learn how to make your DAX queries faster.
11
free
Learn the DAX best practices in common use cases. You may also choose to refer to our book about DAX patterns.

You've achieved DAX mastery – you are now a DAX Guru!

Are you an Excel user?

Start here – you are a DAX Rookie.

1
Learn how to use the Power Pivot add-in for data analysis.
2
free trial
Learn how to master Power Pivot.
3

Practice

Let's build Star Schemas and write simple formulas!
4
Learn how to build data models properly in Tabular.
5
Consolidate your knowledge on data modeling.
6
free trial
Learn how to master the DAX query language.

Congratulations, you've become a DAX Ninja!

7
Consolidate your knowledge of DAX.
8

Practice

Let's work with complex formulas!
9
free
A score higher than 75% is required to proceed to the next step.
10
free trial
Learn how to make your DAX queries faster.
11
free
Learn the DAX best practices in common use cases. You may also choose to refer to our book about DAX patterns.

You've achieved DAX mastery – you are now a DAX Guru!

Are you an Analysis Services pro?

Start here – you are a DAX Rookie.

1
Learn how to master Tabular modeling in Analysis Services.
2
free trial
Learn how to master the DAX query language.

Congratulations, you've become a DAX Ninja!

3
Consolidate your knowledge of DAX.
4

Practice

Let's work with complex formulas!
5
free
A score higher than 75% is required to proceed to the next step.
6
free trial
Learn how to make your DAX queries faster.
7
free
Learn the DAX best practices in common use cases. You may also choose to refer to our book about DAX patterns.

You've achieved DAX mastery – you are now a DAX Guru!