Excel Dax 简明教程

Excel DAX Tutorial

DAX（数据分析表达式）是一种公式语言，可帮助您从数据模型中已存在的数据创建新信息。DAX 公式使您能够执行数据建模、数据分析以及将结果用于报告和决策制定。它是一组函数、运算符和常量，可用于公式或表达式中以计算并返回一个或多个值。DAX 是与 Excel Power Pivot 数据模型关联的公式语言。

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.

Audience

本教程针对所有那些极大地依赖 MS-Excel 来准备包含复杂数据的图表、表格，以及专业报告的读者。它将帮助那些经常使用 MS-Excel 来分析数据的读者。那些使用数据建模和数据分析来进行报告和做决定的专业人士也会受益于本教程。

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.

Prerequisites

本教程是 Excel Power Pivot 教程的扩展，因此在深入了解 DAX 之前，建议先复习一下 Excel Power Pivot 教程。本教程不需要了解 Excel 函数和 Excel 公式，因为 DAX 完全适用于 Power Pivot 窗口中的数据模型。

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.