Dax Functions 简明教程

DAX Functions Tutorial

对于数据建模和报告，DAX 函数在 DAX 的使用中扮演重要角色。它是 DAX 语言中提供的内置函数，它帮助你在数据模型上执行常用的数据计算。有些 DAX 函数与 Excel 函数具有相同名称和功能，但是已经过修改，以便使用 DAX 数据类型并与表和列一起使用。DAX 具有设计为与关系数据一起使用并执行动态聚合的其他函数。

DAX functions play an important role in the usage of DAX for data modeling and reporting. It is an inbuilt function provided in the DAX language that helps you perform commonly used data calculations on the Data Model. Some of the DAX functions have the same names and functionality as that of Excel functions, however, they have been modified to use DAX data types and to work with tables and columns. DAX has additional functions that are designed to work with relational data and perform dynamic aggregation.

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.