training training

DAX: reusable measures and functions in Power BI and Excel

Add additional calculations to the pivot table with Data Analysis Expressions

This training is held in German.
Quite a few people interested in DAX search for the 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 a comprehensible 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

Direct implementation! Work on your own laptop

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 qualification measure after you have registered.

Your benefit

  • You understand the row and filter context and their meaning in the DAX functions.
  • You understand the different areas of application of scalar functions and table functions.
  • You will learn the basic concepts behind the 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.

Methods

Presentation, practical examples and numerous practical exercises on your own PC, sample solutions.

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 participation 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.

Open Badges - Show what you can do digitally too.

Open Badges are recognized, digital certificates of participation. These verifiable credentials are the current standard for integration in career networks such as LinkedIn.

With them, you digitally demonstrate the competences you possess. After successful completion, you will receive an Open Badge from us.

Read more

Further recommendations for "DAX: reusable measures and functions in Power BI and Excel"

Attendees comments

"I particularly enjoyed the lively exchange and the fact that all questions were answered. It was a really good training . It was worth it for me and I will definitely attend more seminars at Haufe Akademie book."

Angela Kampf
Vitesco Technologies GmbH

"I found it particularly helpful that Johannes went into the technical background. The DAX course was great. It increased my understanding enormously."

Olga Winkler
INTER Krankenversicherung AG

"Understood everything without prior knowledge. The good and competent trainers are to be recommended!"

Oliver Czapko
HESKO Industrial Safety GmbH

"I liked the fact that questions from the field were also dealt with very well. The second day was particularly interesting with the more complex applications. As it was a very interactive course and the individual participants and their questions were dealt with very well, I can recommend it to others."

Katja Strahlendorf
MSC Germany

"I liked the way the course was presented, the personal contact with the lecturer and the fact that there was a common didactic thread. The course met all my expectations."

Daniel Starcic
Lenord, Bauer & Co. Ltd.

"Great mix of theory and practice. Critical questioning of functions and statements that you find at Microsoft and on the Internet. Very practical relevance. Very high level of training and good service by the Haufe Akademie ."

Thomas Hirsch
Burda Ciscom GmbH

"Very structured course, friendly and very competent lecturer. The course had a clear central theme."

Dominik Riedinger
Advyce & Perlitz Ltd.

"Brilliant lecturer! I attended 3 seminars (2022/2023) and all were great!"

Frank Voll
ifm group services GmbH

Seminar evaluation for "DAX: reusable measures and functions in Power BI and Excel"

4.6 from 5
with 230 ratings
training content:
4.4
Content comprehensibility:
4.6
Practical relevance:
4.5
Trainer expertise:
4.8
Participant orientation:
4.7
Method variety:
4.5
On-site training together
Booking number
31256
€ 1.540,- plus VAT
2 days
in 3 locations
3 Events
German
In-person trainings
Joint online training
Booking number
32490
€ 1.540,- plus VAT
2 days
Online
8 Events
German
Live online events
Train several employees internally
Pricing upon request
  • Customized training courses according to your needs
  • Directly at your premises or online
  • Cost advantage from 5 participants
  • We contact you within 24 hours (Mon-Fri)
2 days
In-person or Online

Transfer Coaching

Book 2 hours of individual coaching with your trainer.More info

€ 390,-excl. VAT

This training is available as part of course:

Certified Power BI Data Analyst

Start dates and details

  Select time period
0 events
02.06.2025
Live-Online
Booking number: 32490
€ 1.540,- plus VAT.
€ 1,832.60 incl. VAT.
Course
zoom
zoom
Technical notes
We use various software to conduct our online events.
Days & Times
2 days
Limited number of participants

Monday, 02.06.2025

09:00 am - 5:00 pm

Tuesday, 03.06.2025

09:00 am - 5:00 pm

Transfer coaching bookable
2 hours of transfer coaching - live and online with your trainer ensures that you can put what you have learnt into practice in your day-to-day work.
If you book at the same time as your training, you save 10 % on the price of the transfer coaching of € 390,- excl.
07.07.2025
Live-Online
Booking number: 32490
€ 1.540,- plus VAT.
€ 1,832.60 incl. VAT.
Course
zoom
zoom
Technical notes
We use various software to conduct our online events.
Days & Times
2 days
Limited number of participants

Monday, 07.07.2025

09:00 am - 5:00 pm

Tuesday, 08.07.2025

09:00 am - 5:00 pm

Transfer coaching bookable
2 hours of transfer coaching - live and online with your trainer ensures that you can put what you have learnt into practice in your day-to-day work.
If you book at the same time as your training, you save 10 % on the price of the transfer coaching of € 390,- excl.
18.08.2025
Hamburg
Booking number: 31256
€ 1.540,- plus VAT.
€ 1,832.60 incl. VAT.
Venue
Mercure Hotel Hamburg City
Mercure Hotel Hamburg City
Amsinckstraße 53, 20097 Hamburg
Room rate: € 132,97 plus VAT.
Arrival via Deutsche Bahn
Train tickets to this event starting at € 51,90.
Days & Times
2 days
Limited number of participants

Monday, 18.08.2025

09:00 am - 5:00 pm

Tuesday, 19.08.2025

08:00 am - 4:00 pm

Fee includes
The participation fee includes
  • one joint lunch per full seminar day,
  • Catering during breaks and
  • extensive working documents.
The participant will settle the hotel accommodation costs directly with the hotel. You will find a reservation form for hotel bookings in your learning environment.
Transfer coaching bookable
2 hours of transfer coaching - live and online with your trainer ensures that you can put what you have learnt into practice in your day-to-day work.
If you book at the same time as your training, you save 10 % on the price of the transfer coaching of € 390,- excl.
25.08.2025
Live-Online
Booking number: 32490
€ 1.540,- plus VAT.
€ 1,832.60 incl. VAT.
Course
zoom
zoom
Technical notes
We use various software to conduct our online events.
Days & Times
2 days
Limited number of participants

Monday, 25.08.2025

09:00 am - 5:00 pm

Tuesday, 26.08.2025

09:00 am - 5:00 pm

Transfer coaching bookable
2 hours of transfer coaching - live and online with your trainer ensures that you can put what you have learnt into practice in your day-to-day work.
If you book at the same time as your training, you save 10 % on the price of the transfer coaching of € 390,- excl.
17.09.2025
Live-Online
Booking number: 32490
€ 1.540,- plus VAT.
€ 1,832.60 incl. VAT.
Course
zoom
zoom
Technical notes
We use various software to conduct our online events.
Days & Times
2 days
Limited number of participants

Wednesday, 17.09.2025

09:00 am - 5:00 pm

Thursday, 18.09.2025

09:00 am - 5:00 pm

Transfer coaching bookable
2 hours of transfer coaching - live and online with your trainer ensures that you can put what you have learnt into practice in your day-to-day work.
If you book at the same time as your training, you save 10 % on the price of the transfer coaching of € 390,- excl.
20.10.2025
Frankfurt a. M.
Booking number: 31256
€ 1.540,- plus VAT.
€ 1,832.60 incl. VAT.
Venue
Novotel Frankfurt City
Novotel Frankfurt City
Lise-Meitner-Straße 2, 60486 Frankfurt a. M.
Room rate: € 106,81 plus VAT.
Arrival via Deutsche Bahn
Train tickets to this event starting at € 51,90.
Days & Times
2 days
Limited number of participants

Monday, 20.10.2025

09:00 am - 5:00 pm

Tuesday, 21.10.2025

08:00 am - 4:00 pm

Fee includes
The participation fee includes
  • one joint lunch per full seminar day,
  • Catering during breaks and
  • extensive working documents.
The participant will settle the hotel accommodation costs directly with the hotel. You will find a reservation form for hotel bookings in your learning environment.
Transfer coaching bookable
2 hours of transfer coaching - live and online with your trainer ensures that you can put what you have learnt into practice in your day-to-day work.
If you book at the same time as your training, you save 10 % on the price of the transfer coaching of € 390,- excl.
24.11.2025
Live-Online
Booking number: 32490
€ 1.540,- plus VAT.
€ 1,832.60 incl. VAT.
Course
zoom
zoom
Technical notes
We use various software to conduct our online events.
Days & Times
2 days
Limited number of participants

Monday, 24.11.2025

09:00 am - 5:00 pm

Tuesday, 25.11.2025

09:00 am - 5:00 pm

Transfer coaching bookable
2 hours of transfer coaching - live and online with your trainer ensures that you can put what you have learnt into practice in your day-to-day work.
If you book at the same time as your training, you save 10 % on the price of the transfer coaching of € 390,- excl.
18.12.2025
Live-Online
Booking number: 32490
€ 1.540,- plus VAT.
€ 1,832.60 incl. VAT.
Course
zoom
zoom
Technical notes
We use various software to conduct our online events.
Days & Times
2 days
Limited number of participants

Thursday, 18.12.2025

09:00 am - 5:00 pm

Friday, 19.12.2025

09:00 am - 5:00 pm

Transfer coaching bookable
2 hours of transfer coaching - live and online with your trainer ensures that you can put what you have learnt into practice in your day-to-day work.
If you book at the same time as your training, you save 10 % on the price of the transfer coaching of € 390,- excl.
19.01.2026
Live-Online
Booking number: 32490
€ 1.540,- plus VAT.
€ 1,832.60 incl. VAT.
Course
zoom
zoom
Technical notes
We use various software to conduct our online events.
Days & Times
2 days
Limited number of participants

Monday, 19.01.2026

09:00 am - 5:00 pm

Tuesday, 20.01.2026

09:00 am - 5:00 pm

Transfer coaching bookable
2 hours of transfer coaching - live and online with your trainer ensures that you can put what you have learnt into practice in your day-to-day work.
If you book at the same time as your training, you save 10 % on the price of the transfer coaching of € 390,- excl.
11.02.2026
Live-Online
Booking number: 32490
€ 1.540,- plus VAT.
€ 1,832.60 incl. VAT.
Course
zoom
zoom
Technical notes
We use various software to conduct our online events.
Days & Times
2 days
Limited number of participants

Wednesday, 11.02.2026

09:00 am - 5:00 pm

Thursday, 12.02.2026

09:00 am - 5:00 pm

Transfer coaching bookable
2 hours of transfer coaching - live and online with your trainer ensures that you can put what you have learnt into practice in your day-to-day work.
If you book at the same time as your training, you save 10 % on the price of the transfer coaching of € 390,- excl.
23.03.2026
Berlin
Booking number: 31256
€ 1.540,- plus VAT.
€ 1,832.60 incl. VAT.
Venue
relexa Hotel Stuttgarter Hof
relexa Hotel Stuttgarter Hof
Anhalter Straße 8-9, 10963 Berlin
Arrival via Deutsche Bahn
Train tickets to this event starting at € 51,90.
Days & Times
2 days
Limited number of participants

Monday, 23.03.2026

09:00 am - 5:00 pm

Tuesday, 24.03.2026

08:00 am - 4:00 pm

Fee includes
The participation fee includes
  • one joint lunch per full seminar day,
  • Catering during breaks and
  • extensive working documents.
The participant will settle the hotel accommodation costs directly with the hotel. You will find a reservation form for hotel bookings in your learning environment.
Transfer coaching bookable
2 hours of transfer coaching - live and online with your trainer ensures that you can put what you have learnt into practice in your day-to-day work.
If you book at the same time as your training, you save 10 % on the price of the transfer coaching of € 390,- excl.
Sufficient places are still free.
Don't wait too long to book.
Fully booked.
Training is guaranteed to take place
Booking number: 31256
€ 1.540,- plus VAT.
€ 1,832.60 incl. VAT.
Details
2 days
Limited number of participants
Fee includes
The participation fee includes
  • one joint lunch per full seminar day,
  • Catering during breaks and
  • extensive working documents.
The participant will settle the hotel accommodation costs directly with the hotel. You will find a reservation form for hotel bookings in your learning environment.
Transfer coaching bookable
2 hours of transfer coaching - live and online with your trainer ensures that you can put what you have learnt into practice in your day-to-day work.
If you book at the same time as your training, you save 10 % on the price of the transfer coaching of € 390,- excl.
Booking number: 32490
€ 1.540,- plus VAT.
€ 1,832.60 incl. VAT.
Details
2 days
Limited number of participants
Transfer coaching bookable
2 hours of transfer coaching - live and online with your trainer ensures that you can put what you have learnt into practice in your day-to-day work.
If you book at the same time as your training, you save 10 % on the price of the transfer coaching of € 390,- excl.
Book later
You are welcome to make a non-binding advance reservation.
No suitable date?
You are welcome to be notified by e-mail as soon as new dates are released.
Also bookable as in-house training
demand-oriented adaptations possible
on-site or live online for multiple employees
save time and traveling expenses
Please note: We use third-party tools for selected events. Personal data of the participant will be passed on to them for the implementation of the training offer. You can find more information in our privacy policy.

About us – The Haufe Akademie

Your optimizer, innovator and companion since 1978 -
Your professional partner for professional development and seminars, training courses and topical conferences.

Whether on site, live online or in-house - our customised solutions, our claim to the highest level of consulting expertise and training tailored to your needs simplify the acquisition of skills for the working world of the future and sustainably facilitate professional development.

A wide range of seminars, individual coaching and our flexible formats support HR managers and decision-makers in shaping the future and developing employees, in-house teams and companies.

Experience the benefits of online training from the comfort of your own home. Our online formats meet the highest quality standards and are in no way inferior to face-to-face events in terms of practical relevance. Learn together live online in interactive groups or digitally at a time of your choice.

2,500+ further training
600,000+ apprentices per year
Over 95% positive reviews
2,500 trainers and coaches
17,500+ training courses held per year
Call us or send an email

Do you have any questions?

We are there for you Mon - Fri 8 a.m. - 5:00 p.m.

Stephanie Göpfert

Head of Customer Service

*Mandatory fields
FAQs

Questions & Answers

In our Questions & Answers (FAQ) section, you will find all the answers and the most frequently asked questions about your selected topic.