HOME / CATALOG / MICROSOFT POWER BI DAX FROM SCRATCH
EARLY ACCESSDASHBOARDS & BUSINESS INTELLIGENCE PATHLIFETIME ACCESS

Microsoft Power BI DAX from Scratch

Self-paced video training — 11 modules, 30 lessons. Work through it at your own pace — every lesson is real recorded training, not slide-reading.

11
MODULES
30
LESSONS
720p
STREAMING
LIFE
ACCESS
▶INSIDE THE COURSE · 30 LESSONS
UNLOCKS INSTANTLY AFTER CHECKOUTSEE THE CURRICULUM ↓

ABOUT THIS COURSE

In this beginner course, you will learn the fundamentals of DAX (Data Analysis Expressions) used in Microsoft Power BI. You will explore key functions for handling dates and times, manipulating text, and implementing logical operations. Through practical examples, you'll gain the skills to write DAX formulas that enhance your data analysis capabilities.

CURRICULUM

11 modules, in order.

30 LESSONS · LIFETIME ACCESS
01Introduction3 LESSONS
▶Getting Started

learn the basics of getting started with power bi and dax.

▶Syntax

understand the syntax used in dax formulas.

▶Intro to DAX

get an introduction to the dax language and its capabilities.

02DATE and TIME Function4 LESSONS
▶WEEKDAY Function

explore the WEEKDAY function to determine the day of the week.

▶EDATE Function

learn how to use the EDATE function to calculate future dates.

▶EMONTH Function

discover the EMONTH function for calculating end-of-month dates.

▶DATEDIFF and TODAY Function

understand how to use DATEDIFF and TODAY functions for date calculations.

03TEXT Function3 LESSONS
▶FORMAT Function

learn how to format values using the FORMAT function.

▶COMBINEVALUES Function

explore the COMBINEVALUES function for concatenating values.

▶LEFT and FIND Function

understand how to use the LEFT and FIND functions for text manipulation.

04LOGICAL Function5 LESSONS
▶IF Function

learn how to implement conditional logic using the IF function.

▶NESTEDIF Function

explore the NESTEDIF function for advanced conditional statements.

▶AND FUNCTION

discover how to use the AND function for combining conditions.

▶OR Function

learn how to apply the OR function to evaluate multiple conditions.

▶SWITCH Function

understand how to use the SWITCH function for evaluating expressions.

05RELATIONSHIP Function2 LESSONS
▶RELATED Function

explore the RELATED function to access related data in tables.

▶CROSSFILTER

learn about the CROSSFILTER function for modifying filter context.

06X FUNCTION1 LESSONS
▶X FUNCTIONS

get an overview of X functions and their applications in dax.

07FILTER Function3 LESSONS
▶ALL Function

understand how to use the ALL function to remove filters.

▶EARLIER and FILTER Function

learn how to utilize EARLIER and FILTER functions for row context.

▶LOOKUPVALUE

explore the LOOKUPVALUE function for retrieving values from tables.

08STATISTICAL Function2 LESSONS
▶DISTINCTCOUNT Function

learn how to count distinct values using the DISTINCTCOUNT function.

▶RANKX Function

discover how to rank values using the RANKX function.

+ 3 more modules in the full course — 30 lessons total.

CURATED BY

ChartMastery
CURATED LIBRARY

Selected from experienced educators' training libraries and kept whole — modules, worked examples and walkthroughs exactly as taught.

GOOD TO KNOW

Lessons stream in the browser and remember where you stopped.

Watch on two devices at once — phone, tablet or desktop.

Download buttons are disabled; delivery is encrypted and authenticated per request.

$59 · ONE PAYMENT

Own every lesson, for life.

One payment unlocks all 30 lessons instantly — start with lesson one the moment you check out.