What is DAX?
Свайпніть щоб показати меню
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?
Дякуємо за ваш відгук!
Запитати АІ
Запитати АІ
Запитайте про що завгодно або спробуйте одне із запропонованих запитань, щоб почати наш чат
