Accept cookies to show this video. Cookies Policy
Allow all cookies

Introducing DAX Video Course

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.

Collapse allCurriculum

  • 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
    • Measures
    • Aggregation Functions
    • Using Variables

  • Table Functions

    • Table Functions
    • Calculated Tables
    • Filtering a Table
    • Removing Filters
    • Mixing Filters
    • DISTINCT
    • RELATEDTABLE

  • Evaluation Contexts

    • Evaluation Contexts
    • What is an Evaluation Context?
    • Example of a Filter Context
    • Row Context
    • There are Always Two Contexts

  • CALCULATE

    • CALCULATE
    • 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?

  • Conclusion

    • Conclusion
Student Rating
4.9
3100 ratings
89%
8%
1%
1%
1%
Student Reviews (1556)
  • Oscar David Reyes (Sep 12, 2025)

    This world of DAX is very interesting, it is important to understand the contexts of evaluation and transition of contexts.

  • Oscar David Reyes (Sep 12, 2025)

    Very interesting. In fact, the content covers all the most relevant aspects of the DAX language. Context transitions are very complex to understand. But difficult things are exciting. Good things cost a fortune.

  • Amit Rubinfeld (Sep 11, 2025)

    Great course! gives you the exact insights one needs in order to understand the perception of the language, in particular the evaluation contexts. A good start to continue the journey. THANKS

  • Mario Alanis (Sep 6, 2025)

    Es 2025, espero lo traduzcan con IA, excelente curso se que fue grabado en 2017 pero esta muy bueno, espero los creadores esten gozando de sus éxitos sembrados!!!, me gusto mucho!

  • Aditya Karle (Sep 4, 2025)

    I think you should be more clear in your video lectures, telling attendees what to try once the video ends on the sample data provided.

    • – Hi Aditya, Thank you for your comment. The assumption is that what we teach will be applied by our audience in their day-to-day work, on their own data. That's the data they are most familiar with, and most comfortable experimenting on. Thanks, Claire
      Reply by Claire Costa (Sep 5, 2025)
  • Luciano Claudio Caetano da Silva Luciano (Aug 26, 2025)

    Faltou o audio ser em portugues

    • – Hi Luciano, Please note that the subtitles and the transcript are both available in Portuguese indeed, along with 13 other languages. Thanks, Claire
      Reply by Claire Costa (Aug 28, 2025)
  • Varsha R (Aug 14, 2025)

    An amazing tutorial I could not believe was available for free. There were so many conceptual doubts I had but this cleared many of them. I also realize I don't know anything about the logic and how the DAX functions actually work. Highly recommend this series for anyone wanting to get into Power BI. The key is to do everything yourself, whatever the gentlemen in the video are showing you

  • Takami Ryuto-Smith (Aug 12, 2025)

    It was a great course, and I feel that I met the right course which explains DAX in theoretical and practical ways. I really wanted to understand the logics of DAX. I had been using DAX, but it was more likely using DAX without thinking. Knowing what CALCULATE is doing or Context Transition equipped me to the next level. I am very motivated to go to study "Mastering DAX" course now!

  • Abdulrahman Hocaoglu (Aug 12, 2025)

    Greate course for beginners who want to learn DAX and understand how it works

  • Mahesh Karande (Jul 31, 2025)

    Very informative learning. Taught with very simple way. Thank you.

  • Sanjay Kulkarni (Jul 28, 2025)

    Excellent.

  • EUBERT BAUTISTA (Jul 23, 2025)

    clear and precise!

  • Chris Webb (Jul 22, 2025)

    excellent introduction with good mix of theory and demos

  • Abdul Nafie (Jul 20, 2025)

    This is a very good, precise and compact course for anyone wanting to learn DAX from scratch. Very useful for me.

  • Alexander Reburn (Jul 17, 2025)

    Excellent course for beginners!