DAX in Power Pivot
Data Analysis Expressions, or DAX is the formula language used in Power Pivot. Learn about the main functions of the language and how to use them in these courses.
Course List (3)
Data Analysis Expressions, or DAX, is the formula language of Power Pivot, but there are many similarities with Excel formulas. Learn the basic functions of DAX in this course.
Having established a knowledge of the main concepts of the DAX language, this course will demonstrate various common business applications of DAX in Power Pivot. You will see that an understanding of Power Pivot and DAX lets you create more complex and insightful charts and tables, without leaving Excel.
In our second course on Data Analysis Expressions, we’ll look at areas of DAX that can be a little bit more difficult to implement, like time intelligence. We’ll also demonstrate some of the important concepts that underpin DAX, such as contexts and filtering. Once you can understand this course, you’ll be well placed to understand DAX comprehensively.