Self-paced video training — 11 modules, 30 lessons. Work through it at your own pace — every lesson is real recorded training, not slide-reading.
▶INSIDE THE COURSE · 30 LESSONSABOUT 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
learn the basics of getting started with power bi and dax.
understand the syntax used in dax formulas.
get an introduction to the dax language and its capabilities.
explore the WEEKDAY function to determine the day of the week.
learn how to use the EDATE function to calculate future dates.
discover the EMONTH function for calculating end-of-month dates.
understand how to use DATEDIFF and TODAY functions for date calculations.
learn how to format values using the FORMAT function.
explore the COMBINEVALUES function for concatenating values.
understand how to use the LEFT and FIND functions for text manipulation.
learn how to implement conditional logic using the IF function.
explore the NESTEDIF function for advanced conditional statements.
discover how to use the AND function for combining conditions.
learn how to apply the OR function to evaluate multiple conditions.
understand how to use the SWITCH function for evaluating expressions.
explore the RELATED function to access related data in tables.
learn about the CROSSFILTER function for modifying filter context.
get an overview of X functions and their applications in dax.
understand how to use the ALL function to remove filters.
learn how to utilize EARLIER and FILTER functions for row context.
explore the LOOKUPVALUE function for retrieving values from tables.
learn how to count distinct values using the DISTINCTCOUNT function.
discover how to rank values using the RANKX function.
CURATED BY

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
One payment unlocks all 30 lessons instantly — start with lesson one the moment you check out.