How long does the training course last?

6,00 hours(s)

In which language(s) is the training course taught?

When will the next session take place?

11.12.2026

See details

Where does the training course take place?

L'adresse sera fournie ultérieurement

How much does the training course cost?

540,00€

Who is organising this training course?

Fondation créée en 2015 par la Chambre de Commerce et l’Association des Banques et Banquiers Luxembourg (ABBL), la House of Training est un organisme agréé de formation professionnelle continue qui s'engage à contribuer activement à la compétitivité et à l'attractivité du Luxembourg en développant les compétences de ceux qui font vivre son économie.

What are the prerequisites?

Basic knowledge of Power BI Desktop (basic DAX and creating visuals).

What are the aims or the skills being targeted?

This course enables you to create advanced measures in DAX within Power BI Desktop by mastering key functions such as CALCULATE, SUMX, RANKX, AVERAGEX, CONCATENATEX, and Time Intelligence functions like TOTALYTD and DATEADD. You will learn to manipulate filter contexts, apply filters on columns or tables (ALL, REMOVEFILTERS, FILTER), and build complex measures tailored to your analytical needs. Through a practical approach, you will develop concrete skills to enhance your reports and dashboards with powerful, dynamic indicators.

At the end of the course, participants will be able to:

Create advanced measurements in DAX.

What does the training course cover?

Reminders

Create a calculated column
Create a date table using a formula
Create simple measures (SUM, DISTINCTCOUNT)
Use CALCULATE to change the filter context within a formula

Function spotlight: Calculate

Use CALCULATE with column filters
Use CALCULATE with table filters (ALL, ALLSELECTED, REMOVEFILTERS, FILTER)

Iterator Functions

Use SUMX to create a measure based on a calculation at table level (sum of field1*field2, etc.)
Use CONCATENATEX and DISTINCT to create a measure that concatenates all possible values for a fiel
Use RANKX to calculate Ranks
Use AVERAGEX, SUMMARIZE and ADDCOLUMNS to create an average of sums by category

Time Intelligence

Calculate Year-to-Date and Quarter-to-Date values (TOTALYTD, TOTALQTD)
Compare a period to the same period one or more year(s), quarter(s) or month(s) earlier (DATEADD)
Compare a period to its parent period – quarter to year, month to year, etc. (PARALLELPERIOD)