In this course you will learn how you can use DAX to create calculated columns and measures and how you can use DAX as a query language.

In this course you will learn how you can use DAX to create calculated columns and measures and how you can use DAX as a query language.
This course is geared towards Business Intelligence technical professionals
Students must have experience with Business Intelligence and building so-called Tabular Models.
This chapters provides a introduction to the DAX language. Students will learn where DAX can be used, and will see some typical.
A good tools can make the job a lot easier. And DAX Studio is a super handy free tool for DAX developers, independant of whether you are using Power BI Desktop, Excel or Visual Studio in the end. This module explains why and how to use DAX Studio.
When writing scalar expressions a good understanding of the DAX data types, operators and functions is needed.
The CALCULATE function is probably the most used function in DAX when you are defining measures. To really understand how to use the CALCULATE function, you must have a good understanding of the concepts of row and filter contexts, which are also explained in the chapter.
DAX includes time intelligence functions that enable you to manipulate data using time periods, including days, months, quarters, and years, and then build and compare calculations over those periods.
Often measures such as a year-to-date (YTD) calculation have to be repeated for multiple base measures. Calculation groups provide as sort of template with which these repetitive measures can be easily created and maintained.
When you need to iterate through data iterators such as SUMX become useful. This chapter discusses how to work with iterators, and how to apply context transitions within iterators.
Often a measure only makes sense in a certain context (e.g. only relevant at the month level, but not the year level). In this chapter DAX functions are covered which allow you to inspect the current context such that you can protect your measures.
In this last chapter some of the more advanced DAX topics are introduced.
Enter your information to confirm your booking.