2015
Lynda
Ron Davis
2:25
English

You cannot get far in Excel Power Pivot, the future of personal business intelligence, without an understanding of DAX: Data Analysis Expressions. This course teaches you how to unlock DAX's power by understanding its fundamental elements: its syntax, operators, data types, and functions, including the revolutionary CALCULATE function. Author Ron Davis also helps you understand how evaluation context affects DAX expression output, and integrate time and dates into Power Pivot calculations. Start watching now to take your data analysis skills to the next level with DAX.

Introduction
Welcome
What you should know before watching this course
Using the exercise files
1. Introduction to DAX
Getting familiar with DAX
Exploring DAX syntax
Exploring data types
Utilizing operators
Exploring the Power Pivot data model
Understanding errors
2. Using DAX Functions
Using mathematical functions
Using logical functions
Using information functions
3. Understanding Evaluation Contexts
How to proceed through this chapter
Understanding evaluation context for calculated columns and fields
Understanding single table evaluation context
Understanding multiple table evaluation context
Exploring FILTERS and the ALL functions
Understanding the syntax and rules of the CALCULATE function
Exploring how CALCULATE works
Utilizing CALCULATE to change evaluation context
4. Working with Dates
Understanding time intelligence
Sourcing calendars
Working with date functions
Working with DATESINPERIOD functions
Exercising caution with time intelligence
5. Utilizing Advanced DAX Functionality
Utilizing many-to-many relationships
Implementing banding
DAX Studio and EVALUATE
Conclusion
Next steps

Download File Size:391.42 MB

---