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

What is DAX?

Swipe um das Menü anzuzeigen

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?

Wählen Sie die richtige Antwort aus

question mark

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

Wählen Sie die richtige Antwort aus

War alles klar?

Wie können wir es verbessern?

Danke für Ihr Feedback!

Abschnitt 3. Kapitel 3

Fragen Sie AI

expand

Fragen Sie AI

ChatGPT

Fragen Sie alles oder probieren Sie eine der vorgeschlagenen Fragen, um unser Gespräch zu beginnen

Abschnitt 3. Kapitel 3
some-alt