What is DAX?
Pyyhkäise näyttääksesi valikon
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?
Kiitos palautteestasi!
Kysy tekoälyä
Kysy tekoälyä
Kysy mitä tahansa tai kokeile jotakin ehdotetuista kysymyksistä aloittaaksesi keskustelumme
