The illustrations were created in cooperation between humans and artificial intelligence. They show a future in which technology is omnipresent, but people remain at the center.
AI-generated illustration
DAX: reusable measures and functions in Power BI and Excel
Add additional calculations to the pivot table with Data Analysis Expressions
Presence and online
2 days
German
€ 1.540,-
plus VAT.
€ 1.832,60
incl. VAT.
Booking number
31256
Venue
at 4 locations
.svg)
4 dates
€ 1.540,-
plus VAT.
€ 1.832,60
incl. VAT.
Booking number
31256
Venue
at 4 locations
4 dates
€ 1.540,-
plus VAT.
€ 1.832,60
incl. VAT.
Booking number
32490
Venue
Online
10 dates
Become a certified
Machine Learning Engineer
Machine Learning Engineer
This course is part of the certified Master Class "Machine Learning Engineer". If you book the entire Master Class, you save over 15 percent compared to booking this individual module.
To the Master Class
In-house training
In-house training just for your employees - exclusive and effective.
Inquiries
In cooperation with
In cooperation with
Quite a few people interested in DAX search for solutions to their problems on the Internet. However, they usually lack the knowledge to adapt the sample solution. This is where the training comes in: Instead of memorizing DAX functions, the focus is on understanding the basic DAX concepts. Starting with an understandable explanation of the row and filter context, you will get to know the basic DAX functions such as SUMX(), Filter(), ... in order to then understand the meaning of the Calculate() function in the DAX cosmos.
Contents
The basic DAX functions
- The line and filter context.
- The basic scalar functions, such as Sum(), Count(), Max(), ... as well as their bigger brothers SumX(), CountX(), MaxX(), ... and their respective areas of application.
- The table functions Filter(), All(), ... and their meaning.
- The initial and explicit filter context.
- The dangers of nesting X functions.
- Calculate() as the central DAX function and its properties.
- The general table mode and the higher-performance column mode for Calculate().
- The use of variables to better analyze DAX expressions.
- Combination of the various DAX functions Calculate (), Filter(), And(), ... for extensive tasks.
The Time Intelligence functions
- Create period comparisons with e.g. SamePeriodLastYear ().
- Previous year, previous month comparison with PreviousYear, PreviousMonth(), DateAdd().
- Cumulative totals calculations using TotalYTD(), TotalQTD(), TotalMTD() and DatesYTD(), DatesQTD(), DatesMTD().
Tips and tricks
Learning environment
In your online learning environment, you will find useful information, downloads and extra services for this training course once you have registered.
Your benefit
- You understand the row and filter context and their meaning in the DAX functions.
- You understand the different applications of scalar functions and table functions.
- You will learn the basic concepts behind DAX expressions so that you can independently develop solutions for your tasks.
- You will get to know the DAX functions in concrete tasks so that you can apply what you have learned directly in practice.
trainer
Johannes Curio
Nikolas Neuhaus
Fabio Basler
Methods
Presentation, practical examples and numerous practical exercises on your own PC, sample solutions.
Please bring your own laptop to the training .
Final examination
Recommended for
Employees and specialists who work in controlling or finance and want to put their evaluations in Excel PowerPivot and Power BI on a solid footing or expand them. Basic knowledge of Excel or Power BI and basic knowledge of Power Query are recommended prerequisites for participating in the training. Previous knowledge of DAX is not essential.
DAX can be used both in the free Microsoft Excel add-in Power Pivot (from Excel 2010) and in Power BI. This means that the training can be attended by Excel users as well as Power BI users.
.svg)