강의 설명

DAX 기초 배우기

DAX 마스터가 되는 여정을 이 입문 강의와 함께 시작하세요. 보고서에 DAX를 구현하는 데 필요한 기본 개념과 모범 사례를 배우게 됩니다.

계산된 열, 측정값 및 테이블 만들기

DAX 코드를 작성하여 계산 열, 측정값, 테이블을 생성하는 방법을 배우고, Power BI에서 ‘컨텍스트’에 대한 보조 지식도 함께 익히게 됩니다. 마지막으로, 시간 인텔리전스 함수를 소개하며 강의를 마무리하고, Quick Measures를 사용해 복잡한 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