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

What is DAX?

Glissez pour afficher le menu

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?

Sélectionnez la réponse correcte

question mark

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

Sélectionnez la réponse correcte

Tout était clair ?

Comment pouvons-nous l'améliorer ?

Merci pour vos commentaires !

Section 3. Chapitre 3

Demandez à l'IA

expand

Demandez à l'IA

ChatGPT

Posez n'importe quelle question ou essayez l'une des questions suggérées pour commencer notre discussion

Section 3. Chapitre 3
some-alt