From the course: Complete Guide to Power BI for Data Analysts by Microsoft Press

Unlock this course with a free trial

Join today to access over 24,800 courses taught by industry experts.

Understand DAX

Understand DAX - Power BI Tutorial

From the course: Complete Guide to Power BI for Data Analysts by Microsoft Press

Start my 1-month free trial Buy for my team

Understand DAX

“

- [Presenter] So, first off, what is DAX? DAX stands for Data Analysis Expressions. It was modeled initially after the Excel formula language, it is a functional language, much like Excel, so if you're an Excel user and you've written Excel expressions, you're used to nesting functions inside of functions and, therefore, using the DAX language will have a certain degree of familiarity to you. It is used to encapsulate business logic in your data model, and some examples of the use of DAX are calculating a full name from a first name and last name, calculating a gross margin percentage, or perhaps even calculating a year-over-year percentage change. And back many years ago when I first started to teach DAX, I had somebody ask me a very interesting question. They said, "I've been using Power BI for a number of years now, I've built lots of reporting, my executives really love it. They get to interact with their data, it's timely, it's automated, and I've never had to write a stitch of…

Contents