Introduction to DAX

with Dimitar Shutev

Learn Microsoft’s native formula and query language. You can use it with software, such as Power Pivot, Power BI, and SQL Server Analysis Services

3 hours 21 lessons
Start course

Course Overview

Prerequisite for the course: Power Query and Data Modeling DAX (Data Analysis Expressions) is a formula and query language used in Power BI to create calculated columns, measures, and custom tables. Knowing how to use DAX will take your Power BI analysis skills to the next level. In this course, we will show you how to create custom functions, which will help you build sophisticated business reports in Power BI. DAX is easy to learn, especially if you have used Microsoft Excel in the past, as it includes some of the same functions. However, DAX also contains several functions that make the work with relational data easier.

21 High Quality Lessons
1 Practical Tasks
3 Hours of Video
Certificate of Achievement

Topics covered

Custom functionsCustom tablesDAXPower BI custom formulasPower BI queries

What You'll Learn

DAX allows for complex calculations and data queries in related tables and columns in tabular models

How to work with DAX syntax
Create complex calculations and queries on data
Query data in related tables and columns
Use DAX formulas in measures, calculated columns, calculated tables, and role-level security (RLS)
Create custom functions and write your own DAX measures
Improve overall dashboard performance
Student feedback


236 ratings
5 stars
197 (83%)
4 stars
32 (14%)
3 stars
5 (2%)
2 stars
1 (0%)
1 star
1 (0%)
Filter by rating
  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars
  • Newest
  • Oldest
The course content is with no doubt very impressive! The lecturer really knows his stuff and we can easily grasp the information and apply it along the classes, having a great understanding of this software's capacities! I would only add that, as a recorded class, having a script for the recording makes it for a better experience for the students, regarding the objectivity of the subject. I found it a little annoying, the repetitive "ok's" in some classes. It becomes harder not to notice it when you need to forward and backward the video to get points I missed. Overall is great! I only can't make it 5 stars because I can'
I give 4 stars as, if you remove all the clutters, it is a course geared towards experienced users. The name with "introduction" is quite misleading. Other than this, good content and a lot I took away (again, best enjoyed if one is not new to DAX!)
A meaningful course for my cross border sustainability project. The content has been helpful for me to understand the functions and its applicability.
I like the explanations. The lesson got a little hard to follow around variables, but overall everything was very easy to understand.
A real great explanation and step by step for a very difficult topic to me and many .Thanks so much . You are really great
  • 1
  • 2
  • 3
  • ...
  • 5
  • ...
  • 9

“In this course, we are going to introduce you to some of the most useful DAX functions and will teach you how to write your own DAX measures. At the end, you will no longer need to rely on the finance department to give you the numbers for this or last month. Now, you can do that using DAX formulas.”

Dimitar Shutev
Worked at Amadeus, DXC Technology
Introduction to DAX

with Dimitar Shutev

Start Course