This is an introductory video course about the DAX language. DAX is the native language of Power BI, Power Pivot for Excel, and SSAS Tabular models in Microsoft SQL Server Analysis Services. The training is aimed at users of Power BI, Power Pivot for Excel, and at Analysis Services developers that want to move the first steps with DAX.
The goal is to teach the DAX language using Power BI for all the examples. You can download the initial Power BI Desktop file used in the demos and repeat all the steps shown in the videos. The same concepts can be used also on Power Pivot and on Analysis Services Tabular. The course is made of 150 minutes of lectures. You can watch the videos at anytime and the system will keep track of your advances. Within the course you can download the slides and the initial Power BI file used in the demos.
Presentation of Introducing DAX
- Presentation of Introducing DAX Video Course
Slides and examples
- How to download and use the examples
Introduction to DAX
- Introduction to DAX
- What is DAX?
- Calculated Columns
- Aggregation Functions
- Using Variables
- Table Functions
- Calculated Tables
- Filtering a Table
- Removing Filters
- Mixing Filters
- Evaluation Contexts
- What is an Evaluation Context?
- Example of a Filter Context
- Row Context
- There are Always Two Contexts
- What is CALCULATE?
- Filters are Tables
Evaluation Contexts and Relationships
- Evaluation Contexts and Relationships
- Filters and Relationships
- Row Context - Many Tables
- Filter Context - Many Tables
- Context Transition
Time Intelligence in DAX
- Time Intelligence in DAX
- Date Table
- What is Time Intelligence?
- Joseph Bhambal (May 27, 2020)
I'm now really excited to use DAX in my Power BI reports. Looking forward for lots of Fun and new Learning.
- Ricardo Ona (May 25, 2020)
It might be the best DAX course in the whole net. I'm super happy I invested my time watching it. Thank you.
- Yulia Karimova (May 24, 2020)
Excellent course for newbies to DAX wanting to learn more. The information Marco and Alberto provide is truly invaluable given that it's a free course. The explanation of the subject is very clear and structured. A sincere thank you to those who put it together!
- Denilson Salgado (May 24, 2020)
O curso é ótimo, adoraria poder dar continuidade adquirindo o curso completo, mas a cotação do dólar está muito alta em relação a moeda brasileira. O curso vale cada centavo, mas mesmo com desconto, no momento é inviável devido a taxa de câmbio. Vou esperar baixar o dólar. Sorry :(
- Eduardo Angielczyk (May 23, 2020)
By far the best DAX introduction you can ask for
- Denilson Salgado (May 20, 2020)
Obrigado Marco e Alberto. Ótima introdução sobre DAX. Nesse curso, eu pude absorver melhor o conceito sobre funções com resultado escalar e tabela. Principalmente sobre transição e avaliação de contexto (filtro e linha) e como os relacionamentos influenciam. Foi enriquecedor.
- Chris Jamison (May 20, 2020)
Well-paced and incredibly insightful. I am kicking myself that I haven't discovered this resource sooner!
- Ahmed Bouchedoub (May 19, 2020)
Thanks a lot Alberto Ferrari &Marco Russo for this course , it was really amazing and simple any one could easily understand it . I thought at first that Power Bi was about just dashboard and importing Data until i checked sqlbi.com. Lookiong forward for next level Mastering Dax .
- Patti McConnell (May 18, 2020)
Awesome execution. Very easy to follow...thank you Alberto!
- MR MANISHKUMAR MISTRY (May 18, 2020)
Great course to ramp up! Great team work for presenter and speaker! Great content for basic intro! Thanks for the FREE entry!
- jps (May 18, 2020)
The best intro, bright and single, you can find to get a solid foundation to become a pro in DAX language. Thank you very much!
- Victoria Mendaros (May 18, 2020)
Great course. I've learned so much. I like the lecturer, very natural. I like the format of the training where there is an interaction between the presenter and the one who helps him with the slides. I was awake the whole time.
- Luke Fischer (May 17, 2020)
Clear explanations provided a good intro to the language. Thanks Alberto and Marco!
- PAULO AUGUSTO BATISTA JÚNIOR (May 16, 2020)
Parábens, pelo conteúdo disponibilizado. Foi possível reforçar bastantes conceitos da linguagem DAX. E com isso evoluir bastante em meus relatórios.
- Juan manuel Wilke (May 16, 2020)
Very good course as an introducction to DAX. I´ve bought The Definitive Guide to Dax, and this course has help me a lot to follow it.