首页 Business Intelligence

课程

Power BI 中的 DAX 函数

基础技能水平

更新时间 2025年12月

数据分析表达式 (DAX) 可通过编写自定义函数，将你的 Power BI 技能提升到新水平。

免费开始课程

Power BIData Manipulation

3小时

9 视频

25 道练习

2,050 XP

62,856

成就证明

深受数千家公司学习者的喜爱

需要团队培训？

企业版试用

课程描述

掌握 DAX

DAX，即数据分析表达式，是 Microsoft Power BI 中用于创建计算列、度量值和自定义表的公式语言。一旦掌握，DAX 便能让你强大地掌控可视化和报表，从而实现更好的性能和更高的灵活性。

应用上下文

本课程涵盖行查询和筛选上下文等核心概念，并通过练习重点讲解筛选、计数、排名和迭代函数。

先决条件

Introduction to DAX in Power BI Data Modeling in Power BI

1

Setting up Data Models with DAX

In this chapter, you'll write custom functions to create new tables and calculated columns.

DAX for creating tables and columns

Row vs. query vs. filter context

DAX for calculated tables and columns

Creating a date table

Calculated column for costs

Data cleaning with DAX

Connecting data from different tables

2

DAX and Measures

In this chapter, you'll write custom functions to create calculated measures. You'll also get introduced to variables to make writing DAX functions more efficient.

Methods to create DAX measures

Advantages of explicit measures

DAX and Measures

Using variables

Basic statistical measures

Quick measures

3

Filtering and Counting with DAX

Expand your DAX power with some commonly used DAX measures. This chapter focuses on filtering and counting functions.

Filtering and counting with DAX

Understanding different filter functions

Using different filters with DAX

Filter ALL the data

Calculating with a filter

4

Iterating Functions

This chapter covers the core concept of another powerful set of DAX functions, the so called iterating functions. You will explore iterations with exercises focusing on ranking and iterating your data.

Iterating functions

DIY iterating functions

Iterating functions in Power BI

Practice with iterating functions

More iterating functions

Use of RANKX()

Congratulations!

Power BI 中的 DAX 函数

课程完成

获得成就证明

将此证书添加到您的 LinkedIn 档案、简历或履历中
在社交媒体和绩效评估中分享立即注册

加入超过19百万学习者，今天就开始Power BI 中的 DAX 函数！

通过 DataCamp for Mobile 提升您的数据技能

随时随地通过我们的移动课程和每日 5 分钟编程挑战提升技能。