课程描述

学习 DAX 基础知识

通过这门 DAX 入门课程，开启成为 DAX 大师的旅程。你将学习在报表中实现 DAX 的基本概念和最佳实践。

创建计算列、度量值和表

你将学习编写 DAX 代码，以生成计算列、度量值和表，同时掌握 Power BI 中围绕“上下文”的相关基础知识。最后，我们将通过介绍时间智能函数来为本课程收尾，并向您展示如何使用快速度量来创建复杂的 DAX 代码。

让我们迈出掌握 DAX 之旅的第一步！

先决条件

Introduction to Power BI

Getting Started with DAX

In this chapter, you’ll learn how to create custom calculations using Microsoft’s formula language, DAX (Data Analysis Expressions). You’ll learn how to expand your source tables with calculated columns, before progressing to writing calculated measures to help summarize your data.

Introduction to DAX in Power BI

50 XP

Calculated columns vs. measures

100 XP

Creating calculated columns and measures

50 XP

Profit column

100 XP

Sales count

100 XP

Profit margin ratio

100 XP

开始章节

Context in DAX Formulas

In this chapter, you'll learn about context in Power BI and how it plays an important part when building reports. Next, we'll learn how to use iterator functions to evaluate data at a row level. We'll then introduce you to the CALCULATE function to help you filter your data and finally, we'll show you how to use variables to make writing DAX functions more efficient.

Context in DAX formulas

50 XP

The importance of Context

100 XP

Creating DAX measures

50 XP

Using variables

100 XP

Iterator functions

100 XP

Sales by category and year

100 XP

开始章节

Working with Dates

In this chapter, you'll learn the power of DAX's date and time intelligence functions. You'll be able to use these functions in actions, as well as use quick measures to create complex DAX code.

The Date table

50 XP

Creating a calculated table

100 XP

Dates and Quick Measures

50 XP

Expanding the Date table

100 XP

DATEDIFF

100 XP

Your first quick measure

100 XP