From the course: Excel Business Intelligence: Power Pivot and DAX

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Introduction to Data Analysis Expressions (DAX)

Introduction to Data Analysis Expressions (DAX) - Microsoft Excel Tutorial

From the course: Excel Business Intelligence: Power Pivot and DAX

Start my 1-month free trial Buy for my team

Introduction to Data Analysis Expressions (DAX)

“

- [Instructor] Okay, let's talk about what data analysis expressions are all about. Now, simply put, DAX is the formula language that drives Power Pivot. And with DAX you can do a few different things. You can create calculated columns and measures to your model, using intuitive syntax, and you can go well beyond the capabilities of those grid style formulas and functions that you're used to. Because these functions are built specifically to work with relational data and data models. Now, the one biggest takeaway on this slide is that there are two places to use DAX. The first place is the calculated column, and you'll see these in the data view of your data model window. You'll always see this extra add column field, and that's where you can use DAX to create brand new calculated columns. The second place to use DAX is a measure, and you can add measures from a number of different places, but we'll be using them primarily in the pivot table window to calculate some really cool new…

Contents