중급 DAX in Power BI

중급기술 수준

업데이트됨 2026. 5.

다양한 DAX 계산법을 알아보고 Microsoft Power BI에서 이를 활용하는 방법을 배워보세요.

강의 설명

선수 조건

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