Skip to content
Info

Power BI 4 – combining data and DAX calculations

2.9.2025 9:00 - 12:00 Teams

Go deeper with your reports and learn how to use DAX calculations for more complex data models.

Goal

The goal of the course is that you know how to create calculated columns and measures into your data model.

Target audience

This training is for those who already know the basics of Power BI and also, who need to analyze their data in data model.

Program version

In training, we use the latest version of Power BI Desktop. We recommend downloading the application before the start of the training.

Content

Basics first

  • Right type of data is the foundation
  • Requirements for the right table

How to create data model?

  • Relationships between tables
  • One to many or many to one?

Time concept

  • What is date table?
  • When do I need to have date table?

More calculation power with DAX

  • What is DAX?
  • Measure or calculated column?

DAX functions

  • What kind of calculation you can do with DAX-functions? Introduction of DAX functions
  • Mostly used functions, that you really need. RELATED and CALCULATE.

Calculation with summarize functions

  • For example, SUMX and AVERAGEX
  • What to use SUM and when SUMX

Calculation with filters

  • When to use CALCULATE and when FILTER functions
  • Getting rid of duplicates with functions

Time based DAX formulas

  • How to use time-based calculations

Keywords

Power BI, Desktop, Business Intelligence, Power Query, Microsoft Office 365, O365, reporting, visualization, data model, data analyzing, DAX, function, Query Editor, raw data, editing data



Time

 2.9.2025 9:00 - 12:00

Location

Teams

Language

English

Organizer

Eduhouse

Price

Participation in this training is free of charge for YKA members. 

Registration

Please read YKA’s registration instructions (second tab) carefully before signing up.
Register for this training by 9:00 AM on August 31, 2025, through Eduhouse via the following link:
https://trainings.eduhouse.fi/en/koulutukset/power-bi-level-4-combining-data-and-dax-calculations/

After the registration deadline, you can inquire about available spots via Eduhouse's chat or by emailing: trainings@eduhouse.fi

Questions?

Questions and feedback about the YKA–Eduhouse collaboration:
koulutukset@yka.fi

Questions about Eduhouse trainings and registrations:
trainings@eduhouse.fi

You can also use the chat feature on Eduhouse’s website!
https://trainings.eduhouse.fi/