DAX (Data Analysis Expressions) is a formula language that helps you create new information from the data that already exists in your Data Model. DAX formulas enable you to perform data modeling, data analysis, and use the results for reporting and decision making. It is a collection of functions, operators, and constants that can be used in a formula or expression to calculate and return one or more values. DAX is the formula language associated with the Data Model of Excel Power Pivot.

This tutorial has been designed for all those readers who depend heavily on MS-Excel to prepare charts, tables, and professional reports that involve complex data. It will help all those readers who use MS-Excel regularly to analyze data. Professionals who use data modeling and data analysis for reporting and decision-making purposes will benefit from this.

This tutorial is an extension to Excel Power Pivot tutorial, hence it is a good idea to brush up on the Excel Power Pivot tutorial before you delve into DAX. Knowledge of Excel Functions and Excel Formulas is not necessary for this tutorial, as DAX is entirely for the Data Model in the Power Pivot window.

Course Content

Excel DAX Tutorial
DAX Home
DAX Overview
Excel DAX Calculated Columns
Excel DAX Calculated Fields / Measures
Excel DAX Editing a Calculated Field
DAX Deleting a Calculated Field
Excel DAX Syntax
Excel DAX Operators
Excel DAX Standard Parameters
Excel DAX Functions
Excel DAX Understanding DAX Functions
Excel DAX Evaluation Context
Excel DAX Formulas
Updating the Results of DAX Formulas
Excel DAX Updating Data in the Data Model
Excel DAX Recalculating DAX Formulas
Troubleshooting DAX Formula Recalculation
Excel DAX Formula Errors
Excel DAX Time Intelligence
Excel DAX Filter Functions
Excel DAX Scenarios
Excel DAX Performing Complex Calculations
Excel DAX Working with Text and Dates
Conditional Values and Testing for Errors
Excel DAX Using Time Intelligence
Excel DAX Ranking and Comparing Values
Excel DAX Useful Resources
Excel DAX Quick Guide
DAX Useful Resources
Discuss Excel DAX

Student Feedback

Course Rating