Go to content
We are the #1 Microsoft partner of the Netherlands
#1 Microsoft partner of NL
Console

Mastering DAX (English)

€ 1.149,- (excl. VAT) 2 days Online, Utrecht

Description

In the "Mastering DAX" training, you will learn to recognize important patterns that can be solved simply, powerfully, and dynamically with DAX.

DAX is fundamentally a simple language: with some basic Excel knowledge, you can quickly create your first calculated column. But when you start doing more complex analyses, you soon encounter questions like:

  • How can I easily calculate a percentage of the total?
  • How do I use inactive relationships between tables?

Over two days, we will work with questions and cases that often arise when working with DAX.

Prerequisites for the "Mastering DAX" training

In this training, it's important to have a basic knowledge of Power BI. The ability to create simple reports and perform basic data analyses (without writing DAX yourself) is required. Previous exposure to DAX is helpful, but not necessary: we explain everything.

It's also important to be able to model your data in a Dimensional Model. As long as your data model is correct, you need much less complex DAX logic in practice.

Finally, as a participant, you need access to Power BI Desktop on your own (work) laptop.

Topics

  • Understanding DAX: how it really works
  • The difference between Row context and Filter context.
  • Calculated Columns and Measures: when to use what?
  • Creating a Date table with DAX
  • Looking up values in other tables: LOOKUPVALUE, RELATED + RELATEDTABLE
  • Summarizing numbers with: SUM, AVERAGE + COUNT
  • Modifying Filter Context with: CALCULATE + FILTER
  • Working with Time Intelligence functions: PREVIOUSMONTH, PARALLELPERIOD + DATESYTD
  • How to handle many-to-many relationships?
  • Securing data with Row-Level Security

Study Material

In the DAX for Power BI training, we use material developed by us at Wortell Smart Learning. We ensure that you receive all the necessary material in time.

Available dates

Starts at
Ends at
Location
Price (ex. VAT)
Price (inc. VAT)
Enroll
Actions
Starts at:
Ends at:
Location: Utrecht
Price (ex. VAT): € 1.149,-
Price (inc. VAT): € 1.390,29
Starts at:
Ends at:
Location: Online
Price (ex. VAT): € 1.149,-
Price (inc. VAT): € 1.390,29
Starts at:
Ends at:
Location: Utrecht
Price (ex. VAT): € 1.149,-
Price (inc. VAT): € 1.390,29
Starts at:
Ends at:
Location: Online
Price (ex. VAT): € 1.149,-
Price (inc. VAT): € 1.390,29

Unlimited learning for a fixed price with Unlimited Learning.

Unlimited learning for a fixed monthly price. Whether you go solo or as a team, we are ready to meet your knowledge goals.