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

What is DAX?

Swipe to show 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?

Select the correct answer

question mark

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

Select the correct answer

Everything was clear?

How can we improve it?

Thanks for your feedback!

Section 3. Chapter 3

Ask AI

expand

Ask AI

ChatGPT

Ask anything or try one of the suggested questions to begin our chat

Section 3. Chapter 3
some-alt