What is DAX?
Desliza para mostrar el menú
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?
¡Gracias por tus comentarios!
Pregunte a AI
Pregunte a AI
Pregunte lo que quiera o pruebe una de las preguntas sugeridas para comenzar nuestra charla
