Power BI 中级 DAX

中级技能水平

更新时间 2026年5月

掌握丰富的 DAX 计算，并学习如何在 Microsoft Power BI 中使用它们。

课程描述

DAX 逻辑函数

本课程将带您了解新的 DAX 函数及其多种应用场景。首先，你将通过学习如何编写逻辑函数来扩展你的核心 DAX 知识。

使用 DAX 实现行级安全性

其次，你将了解如何编写用于行级安全性（RLS）的 DAX 函数，以及如何使用 DAX 操作表并创建嵌套函数。那些时间智能快速度量很快就会自动构建起来！

先决条件

Introduction to DAX in Power BI Data Modeling in Power BI

Logical Functions

In this chapter, you'll dive into logical functions! You’ll learn how to combine IF with other Power BI functions and discover the robust SWITCH function.

Logical functions

50 XP

Interpreting SWITCH()

50 XP

Logical functions in Power BI

50 XP

IF() for formatting tables

100 XP

Exploring SWITCH()

100 XP

Grouping

100 XP

开始章节

Row-level Security

In the second chapter, you'll learn about row-level security, allowing you to change what data users see depending on their roles and permissions.

Row-level security

50 XP

Applying row-level security

50 XP

Managed roles in Power BI

50 XP

Creating an email list

100 XP

Implementing RLS

100 XP

Security filtering

100 XP

开始章节

Table Manipulation Functions

In this chapter, you'll learn table manipulation functions in DAX. Let's summarize!

Table manipulation functions

50 XP

Summary of SUMMARIZE()

50 XP

Table manipulations using DAX

50 XP

SUMMARIZE() the facts

100 XP

ADDCOLUMNS()? No problem!

100 XP

开始章节

Time Intelligence Functions

In this last chapter, you'll expand your DAX knowledge with time intelligence functions. You'll even explore a way to create advanced visuals without writing DAX.

Time intelligence functions

50 XP

Time intelligence functions output

100 XP

Time intelligence in Power BI

50 XP

Use of TOTALYTD()

100 XP

Use of SAMEPERIODLASTYEAR()

100 XP

Build your own YoY quick measure

100 XP