中級 DAX in Power BI

中級スキルレベル

更新日 2026/05

Microsoft Power BIにおける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