Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Lære What Is DAX? | Power BI for Beginners
Power BI for Beginners

What Is DAX?

Stryg for at vise menuen

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?

Vælg det korrekte svar

question mark

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

Vælg det korrekte svar

Var alt klart?

Hvordan kan vi forbedre det?

Tak for dine kommentarer!

Sektion 1. Kapitel 14

Spørg AI

expand

Spørg AI

ChatGPT

Spørg om hvad som helst eller prøv et af de foreslåede spørgsmål for at starte vores chat

Sektion 1. Kapitel 14
some-alt