# Power BI DAX Masterclass Measures & Calculated Columns

Master advanced analysis with DAX – Learn Measures & Calculated Columns in Power BI (Advanced)!

4.5/5

## Power BI DAX Masterclass Measures & Calculated Columns

### What you’ll learn

Create your own Measures & Calculated Columns in DAX
Use DAX in Power BI for advanced data analysis
Understand the concepts behind Measures & Calculated Columns in DAX
Learn how to use the most important DAX functions
Create better reports with Measures & Calculated Columns

### Requirements

Some basic knowledge in Power BI is required

### Overview

Section 1: Introduction

Lecture 1 Welcome!

Lecture 2 Our Data & Our Project

Lecture 3 DAX Cheat Sheet

Section 2: DAX Basics

Lecture 5 Measures vs. Calculated Columns

Lecture 6 Automatically create a date table with CALENDARAUTO

Lecture 7 CALENDAR

Lecture 8 How to create a complete date table

Lecture 9 Script to reuse in your project for date tables

Lecture 10 Key Measures table

Lecture 11 Aggregation functions

Lecture 12 COUNT, COUNTA, COUNTBLANK,DISTINCTCOUNT & COUNTROWS

Lecture 13 SUMX – How does it work?

Section 3: Practical Exercises No. 1

Lecture 14 Exercises

Lecture 15 Solutions

Section 4: Filter context vs. Row context

Lecture 16 Power BI vs. Excel

Lecture 17 Filter context

Lecture 18 Row context

Lecture 19 Data model and DAX

Section 5: CALCULATE & Table filters

Lecture 20 CALCULATE Basics

Lecture 21 FILTER

Lecture 22 ALL

Lecture 23 ALLSELECTED

Lecture 24 ALLEXCEPT

Section 6: Practical Exercises No. 2

Lecture 25 Exercises

Lecture 26 Solutions

Section 7: Advanced possibilities with DAX

Lecture 27 Logical operators

Lecture 28 Commenting and Formatting

Lecture 29 VALUES & AVERAGEX

Lecture 30 RANKX

Lecture 31 IF & Top-N-Filter

Lecture 32 Variables

Section 8: Practical Exercises No. 3

Lecture 33 Exercises

Lecture 34 Solutions

Section 9: Time Intelligence

Lecture 35 Time Intelligence & DATEADD

Lecture 36 Year-to-Date & Month-to-Date

Lecture 37 TOTALYTD vs. DATESYTD

Lecture 38 DATESBETWEEN

Section 10: Formatting your Data with DAX

Lecture 39 ROUNDING (Numbers, Currency & Time)

Lecture 40 FORMAT (Predefined Numbers)

Lecture 41 Custom Formatting (Numbers)

Lecture 42 Custom Formatting (Time)

Lecture 43 Formatting Dates

Section 11: Quick Measures

Lecture 44 Quick Measures – How to use them?

Lecture 45 Quick Measures – Filters

Lecture 46 Quick Measures – Time Intelligence

Lecture 47 Quick Measures – Rolling Average

Lecture 48 Quick Meausres – Aggregation per category

Lecture 49 Quick Measures – Mathematical operations & text operations

Section 12: Create your own report – Mini project

Lecture 50 Intro to our mini project

Lecture 51 First set of key measures

Lecture 52 Gross, net & profit filtering

Lecture 53 Combining measures with time filtering

Lecture 54 Report creation – part 1

Lecture 55 Report creation – part 2

Section 13: Bonus

Lecture 57 Bonus lecture

Everyone that wants to know more about Power BI and wants to use DAX for Calculated Columns and Measures

#### Course Information:

Udemy | English | 5h 48m | 1.63 GB
Created by: Nikolai Schuler

You Can See More Courses in the Business >> Greetings from CourseDown.com

Scroll to Top