Mastering DAX Calculations in Microsoft Power BI

Course Curriculum

Chapter 1: Introduction to DAX

Lecture 1: Learning Tips From Enterprise DNA

Lecture 2: Microsoft Power BI user-interface updates to be aware of

Lecture 3: Course Overview – Let's get started!

Lecture 4: Unlocking Intriguing Insights: Facts about DAX

Lecture 5: Resource Download

Lecture 6: Mastering DAX: Introduction and Learning Path

Lecture 7: Data Types and Operators in DAX

Lecture 8: The Importance of Naming Conventions in DAX Formulas

Lecture 9: Understanding Formula Syntax in DAX

Lecture 10: Working with Measure Groups in Power BI

Lecture 11: Formatting DAX Code for Readability

Lecture 12: Simplifying Formulas with Variables in DAX

Lecture 13: Writing comments in your code

Lecture 14: Harnessing the Power of Quick Measures in Power BI

Lecture 15: Optimizing Data Model and Relationships for DAX

Lecture 16: The only way to learn is to practice

Lecture 17: Introduction to DAX – Review

Lecture 18: Key Insights for Effective DAX and Power BI Use

Chapter 2: DAX Basics

Lecture 1: Did You Know? Facts about DAX

Lecture 2: Calculated Columns vs. Measures in DAX

Lecture 3: Understanding Context and the DAX Calculation Engine

Lecture 4: Evaluation Context in DAX

Lecture 5: Aggregation Context in DAX

Lecture 6: Iterations or row context in DAX

Lecture 7: Context Transition in Calculated Columns

Lecture 8: Filter Propagation in Data Models

Lecture 9: DAX Basics – Review

Lecture 10: Principles of DAX Calculations and Context

Lecture 11: Your Feedback Matters!

Chapter 3: Getting started with DAX

Lecture 1: DAX Uncovered: 3 Facts

Lecture 2: Exploring Different DAX Function Types

Lecture 3: Aggregation Functions: SUM, AVERAGE, MIN, MAX

Lecture 4: More Aggregators – COUNT/COUNTA/COUNTBLANK/COUNTROWS/DISTINCTCOUNT

Lecture 5: Iteration Functions – SUMX/AVERAGEX/MINX/MAXX

Lecture 6: Branching Methodology for Measures

Lecture 7: Combining DAX Functions for Powerful Calculations

Lecture 8: Error Handling with BLANK, ISBLANK, IFERROR

Lecture 9: Logical Functions: IF, SWITCH

Lecture 10: Dividing Numbers with DIVIDE Function

Lecture 11: Exploring Other Function Types in DAX

Lecture 12: Getting Started with DAX – Review

Lecture 13: Learning DAX Functions for Enhanced Data Analysis in Power BI

Chapter 4: Introducing Simple Table Functions

Lecture 1: Hidden Powers of DAX: 3 Facts

Lecture 2: Understanding Table Functions and Virtual Tables

Lecture 3: Filtering Tables with FILTER Function

Lecture 4: Utilizing the Versatile VALUES Function

Lecture 5: VALUES vs. DISTINCT: Choosing the Right Function

Lecture 6: VALUES vs. SELECTEDVALUE: Handling Single Values

Lecture 7: Removing Filters with ALL Function

Lecture 8: Removing Filters with ALL and ALLEXCEPT Functions

Lecture 9: Comprehensive Understanding of ALLSELECTED Function

Lecture 10: Introducing Simple Table Functions – Review

Lecture 11: Deep Dive into DAX Table Functions and Filtering in Power BI

Chapter 5: Expanding on CONTEXT

Lecture 1: CONTEXT Basic Facts

Lecture 2: Managing Filter and Row Context with Relationships

Lecture 3: Working with Single and Multiple Tables in Context

Lecture 4: Controlling Context with ISFILTERED and ISCROSSFILTERED Functions

Lecture 5: Navigating Relationships with RELATED Function

Lecture 6: Understanding Time-Based Context with EARLIER Function

Lecture 7: Expanding on Context – Review

Lecture 8: Quick Insights on Context Management and Navigating Relationships in DAX

Chapter 6: CALCULATE statement

Lecture 1: Redefining Data with DAX

Lecture 2: The Importance of CALCULATE in DAX

Lecture 3: Understanding the Role of CALCULATE and Context Interaction

Lecture 4: Expanding Functionality with CALCULATE

Lecture 5: How are formula calculated when you involve CALCULATE?

Lecture 6: Calculating with User Relationships: USERELATIONSHIP Function

Lecture 7: Applying Simple and Advanced Filters with CALCULATE

Lecture 8: Calculate Statement – Review

Lecture 9: Deciphering the Power of CALCULATE in DAX

Chapter 7: Time Intelligence Functions

Lecture 1: The Power Time: Quick Facts

Lecture 2: Exploring Time Intelligence Functions in DAX

Lecture 3: Leveraging the Power of Date Tables in Power BI

Lecture 4: Comparing Dates with DATEADD Function

Lecture 5: DATEADD vs. SAMEPERIODLASTYEAR: Analyzing Time Comparisons

Lecture 6: Aggregating Data with YTD, QTD, and MTD Functions

Lecture 7: Analyzing Time Periods with PREVIOUSMONTH and PARALLELPERIOD

Lecture 8: Information about Time with OPENINGBALANCEMONTH, STARTOFMONTH, ENDOFYEAR

Lecture 9: Working with Date Ranges using DATESBETWEEN, DATESINPERIOD, DATEDIFF Functions

Lecture 10: Practical Examples of Time Intelligence Functions in Action

Lecture 11: Time Intelligence Functions – Review

Lecture 12: Time Intelligence in DAX for Effective Reporting

Chapter 8: Advanced Techniques For Variables

Lecture 1: DAX in Depth: Variables

Lecture 2: Understanding how variables are evaluated

Lecture 3: Simplifying Formulas with Table Variables