Interested in a private company training? Request it here.
This chapters provides a introduction to the DAX language. Students will learn the different use-cases of the DAX language.
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.
Nearly all analysis happens against different time periods. DAX includes time intelligence functions that enable you to manipulate data using time periods, and then build and compare calculations over those periods. Common challenges such as year-to-date, growth calculations, moving averages etc. are covered in this module.
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. A typical use case are percentage of parent calculations, which are discussed in detail.
Power BI is a suite of business analytics tools to analyze data and share insights. DAX (short for Data Analysis Expressions) is a language used in Power BI and Analysis Services Tabular Models to create derived calculations such as year-to-date, percentage of total, etc. In this course you will learn how you can use DAX to create measures and other derived calculations. You will also learn to use DAX as a query language.
This course is intended for people who have a background in Business Intelligence and have already builded data models in Power BI or Analysis Services. U2U also offers a 3-day course Analyzing your data with Power BI for Business Users targeted at people without any skills to build a Tabular Model.