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
21 High Quality Lessons
1 Practical Tasks
3 Hours of Content
Certificate of Achievement

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.

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


420 ratings
5 stars
353 (84%)
4 stars
53 (13%)
3 stars
10 (2%)
2 stars
3 (1%)
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'
One of the serious weaknesses of Power BI courses is that these courses do not have booklets, exercises and projects. I think that PowerBi is a powerful tool and it is necessary for the managers of Learn 365 to work more on this courses. I expect more from these Power BI courses, much more. Like Python, Excel courses, and so on.
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!)
Good introduction to DAX. It is easy to follow even for the new comer for power bi. Improvement point: It will be better if you can show the formula in the formula bar in bigger font size
A meaningful course for my cross border sustainability project. The content has been helpful for me to understand the functions and its applicability.
  • 1
  • 2
  • 3
  • ...
  • 7
  • ...
  • 13
Dimitar Shutev

“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