Introduction to DAX

with Dimitar Shutev
4.8/5
(414)

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

Curriculum

Student feedback

4.8/5

414 ratings
5 stars
349 (84%)
4 stars
51 (12%)
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
Clear all
Sort
  • Newest
  • Oldest
Clear all
Rafael Rodrigues de Siqueira
15.12.2022
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'
Daniel Naseri
14.01.2024
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.
Bare Udusegbe
20.11.2022
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!)
Pichet Kaytanyaluk
13.11.2023
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
Hashim Salleh
24.01.2023
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
  • ...
  • 12
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

Courses You May Like

The Complete Data Visualization Course with Python, R, Tableau, and Excel

The Complete Data Visualization Course with Python, R, Tableau, and Excel

with Elitsa Kaloyanova
4.8/5
(1010)
9 hours 100 lessons
Introduction to R Programming

Introduction to R Programming

with Simona Dobreva, Iliya Valchanov
4.8/5
(607)
7 hours 174 lessons
Data Preprocessing with NumPy

Data Preprocessing with NumPy

with Viktor Mehandzhiyski
4.8/5
(800)
8 hours 68 lessons
Data Cleaning and Preprocessing with pandas

Data Cleaning and Preprocessing with pandas

with Martin Ganchev
4.7/5
(1268)
3 hours 27 lessons
SQL

SQL

with Martin Ganchev, Vladimir Saev
4.8/5
(3145)
12 hours 242 lessons
Python Programmer Bootcamp

Python Programmer Bootcamp

with Giles McMullen-Klein
4.8/5
(2527)
20 hours 128 lessons
Introduction to Jupyter

Introduction to Jupyter

with Martin Ganchev
4.8/5
(2453)
1 hour 9 lessons
SQL + Tableau

SQL + Tableau

with Martin Ganchev
4.8/5
(623)
5 hours 20 lessons
Git and GitHub

Git and GitHub

with Giles McMullen-Klein
4.7/5
(1415)
1 hour 12 lessons
Introduction to Python

Introduction to Python

with Martin Ganchev
4.8/5
(3058)
3 hours 41 lessons
Dates and Times in Python

Dates and Times in Python

with Ivan Manov, Martin Ganchev
4.9/5
(258)
3 hours 46 lessons
Power Query and Data Modeling

Power Query and Data Modeling

with Dimitar Shutev
4.8/5
(628)
2 hours 21 lessons
Building Business Reports Using Power BI

Building Business Reports Using Power BI

with Dimitar Shutev
4.8/5
(488)
2 hours 15 lessons
Working with Text Files in Python

Working with Text Files in Python

with Martin Ganchev
4.8/5
(240)
2 hours 22 lessons
Intermediate Python Programming

Intermediate Python Programming

with Martin Ganchev
4.8/5
(438)
1 hour 13 lessons
Advanced SQL

Advanced SQL

with Martin Ganchev, Vladimir Saev
4.8/5
(300)
7 hours 40 lessons

Introduction to DAX

with Dimitar Shutev

Start Course