Writing DAX Queries

DAX is much more than a language for writing measures. It's also a powerful and full-featured query language

4.42 (465 reviews)

Udemy

platform

English

language

Other

What you will learn

The difference between a DAX measure and a full DAX query

The tools available to write full DAX queries

How to construct a DAX query

The importance of data lineage and the TREATAS function

How to write common T-SQL queries as DAX queries

The most common and useful DAX table functions when writing DAX queries

How to export the results of your DAX queries to CSV and SQL Server

15 questions and exercises to test your knowledge

Why take this course?

As a DAX developer you've probably written many measures, expressions and code for calculated columns. But, DAX is also a full featured and powerful query language for retrieving data in a table format, much like SQL. There is much more to being a professional DAX developer than just writing measures.

The goal of this course is to teach the student what a complete DAX query is and how to read and write one. You'll learn how a query is constructed, the tools available to execute your queries, exporting data and all the various DAX table functions available to help you create and manipulate data. We'll then help make the transition from being a T-SQL developer to a DAX developer a bit easier by comparing common query scenarios.

Finally you'll have a change to test your knowledge with 15 questions and exercises.

Screenshots

Reviews

September 21, 2023

I think there is an error in exercise 8 solution. The top 5 are sales of all countries rather than that of Canada only. The generate function crossjoin 2 tables; the first table has been filtered for Canada to get the years, but the second table has not been filtered for Canada.

Ezekiel

September 8, 2023

I got to learn more about DAX in a deeper level beyond PowerBI, specifically how it can be used for table queries.

Sai

August 22, 2023

The DAX queries is used in our Day-to-day life where there given best examples with advance topics, given clear explanations. The New topic in this what i learn was Connecting to SQL Server and writing the DAX and TREATAS

Anonymized

August 8, 2023

El contenido del curso es bueno pero quizá debe de profundizar en el temario ya que dentro de un modulo se podían ver mas de más funciones que las anteriores.

Hari

November 30, 2022

This Course is very good. Someone who wants to know about that DAX query, must take this course. The instructor explains the Queries in very interest way.

Baranyai

September 16, 2022

Practical, useful course with very good explanations. I recommend it to everyone who wants to dive deeper into writing DAX queries. + (this is my 7th course from Randy, I may be a bit biased already :-) , so I recommend this course after completing DAX part1 and part2, as well as the DAX Studio course, they are also must-haves :-) )

Jair

August 16, 2022

Hi Randy. Thanks for this course, it was great. Hope to be able to take more courses from you and your team. Great learning experience :)

Girish

August 15, 2022

Yes so far so good but should cover and start from basics how to install where is the resource file how to open in the Power BI environment

Mary-Juliet

July 26, 2022

Some functions that I did not understand in the previous course before this, was properly explained in this course and now, I understand much better.

Jozsef

July 16, 2022

So far so good, although the instructor should have pointed out that Resources are available at this stage like other instructors do

Bujor

November 11, 2021

It's only now that I understand how to use DAX Studio, even if I've been writing DAX measures for a while. I like Randy's style of teaching: it's simple and to the point, he doesn't waste time writing the queries (when it's much more important to explain them) and he has exercises to conclude the course. This is one of the few courses I have taken that includes exercises that actually make sense. I'm looking forward for the next course.

William

October 30, 2021

Randy does a great job by demonstrating the concepts and principals with meaningful examples. I enjoy all of the content Randy publishes on Udemy.

Ted

August 25, 2021

Wow, what an awesome course! Especially for those of use who "thought" we understood DAX. Great Job, Thanks!

Cruz

March 31, 2021

It is great, pretty straight forward working with DAX, no need to go through install steps or anything. DAX and DAX only. Love it!

Craig

January 12, 2021

Very good course describing the functions and how to write Dax. However, I believe its intended for an individual who has already has a good ideal of Dax (developer) and not someone who is starting out and looking to improve their understanding. Nevertheless, I would recommend it for an intermediate/ experienced user.

Charts

Price

Rating

Enrollment distribution

Writing DAX Queries - Distribution chart