Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Leer What is DAX? | Data Modeling and DAX Fundamentals
Power BI for Beginners

What is DAX?

Veeg om het menu te tonen

DAX (Data Analysis Expressions) is the formula language that powers calculations in Power BI. In this chapter, you'll get a clear, plain-language introduction to what DAX is, how it differs from Excel formulas, and when to use each of its two main calculation types: calculated columns and measures.

You'll learn the critical difference between a calculation that runs row by row (calculated column) and one that responds to the current filters in a report (measure). You'll also create a dedicated Measures table to keep your model organized, and write your very first DAX measure from scratch.

1. You want to calculate total revenue that updates automatically when a user filters by region in a report. Should you use a calculated column or a measure?

2. In the DAX formula "Total Sales = SUM(Sales[TotalAmount])", what do the square brackets indicate?

question mark

You want to calculate total revenue that updates automatically when a user filters by region in a report. Should you use a calculated column or a measure?

Selecteer het correcte antwoord

question mark

In the DAX formula "Total Sales = SUM(Sales[TotalAmount])", what do the square brackets indicate?

Selecteer het correcte antwoord

Was alles duidelijk?

Hoe kunnen we het verbeteren?

Bedankt voor je feedback!

Sectie 3. Hoofdstuk 3

Vraag AI

expand

Vraag AI

ChatGPT

Vraag wat u wilt of probeer een van de voorgestelde vragen om onze chat te starten.

Sectie 3. Hoofdstuk 3
some-alt