An introduction to DAX
This chapters provides a introduction to the DAX language. Students will learn the how to define calculated columns and measures, the DAX data types, how to define variables in DAX and how to deal with errors. Also the usage of common aggregation and iterator functions like SUM, MIN, MAX, SUMX, MAXX, MINX,... are covered in this chapter.
- Overview of a Tabular Model
- DAX use cases
- Understanding calculated columns and measures
- DAX data types
- Introducing DAX variables
- Handling errors in DAX
- Basic Aggregation and Iteration functions
- DAX as a query language
Querying Tabular Models
In this module students will learn how to query data models using the DAX EVALUATE function. Also filtering, sorting and grouping results is covered in this chapter. Students will learn how to use DAX Studio to execute these queries.
- Introducing DAX Studio
- Using the EVALUATE function
- Sorting and filtering results
- Implementing paging
- Grouping results using SUMMARIZE
- Retrieving metadata
- Performance monitoring
Table functions in DAX
- Introduction to table functions
- The FILTER function
- The ALL and ALLEXCEPT functions
- The DISTINCT and VALUES functions
- The RELATEDTABLE function
- Using a table as a scalar value
The CALCULATE function in DAX
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.
- Introduction to the CALCULATE function
- The CALCULATE function and the row and filter context
- Filtering with the CALCULATE function
- The ISFILTERED and ISCROSSFILTERED function
- The HASONEVALUE function
- Calculating ratios and percentages
Working with Iterators
- Using Iterator functions
- Computing averages moving averages
- Using RANKX
- RANKX and HASONEVALUE
- Optional parameters of the RANKX function
Time Intelligence with DAX
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.
- Creating calendar tables using CALENDAR and CALENDARAUTO
- Working with multiple data tables
- Mark as Data Table
- Computing YTD/QTD and MTD totals
- Comparing data over time using DAX
- Calculating Rolling Totals
- Calculating Moving Averages
- Overview of semi-additive measures
- Working with Opening and Closing Balances
- Advanced Time Intelligence functions
Power BI is a suite of business analytics tools to analyze data and share insights. Power BI Desktop transforms your company's data into rich visuals for you to monitor your business and get answers quickly with rich dashboards available on every device.
DAX or Data Analysis Expressions is a language used in Power BI, SQL Server Analysis Services Tabular Models and Power Pivot for Excel to define expressions and formulas.
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 intended for technical people who have a background in Business Intelligence and building so-called Tabular Models.
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.