Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Advanced DAX in Microsoft Power BI for Data Analysis
Rating: 4.2 out of 5(26 ratings)
438 students

Advanced DAX in Microsoft Power BI for Data Analysis

Master advanced DAX, CALCULATE, time intelligence, filter context, and analytics in Power BI
Created byExcel Mojo
Last updated 5/2026
English

What you'll learn

  • Understand how DAX engines work in Microsoft Power BI
  • Master CALCULATE, filter context, row context, and context transition concepts
  • Build advanced DAX calculations using scalar and logical functions
  • Work with advanced table functions and calculated tables in Power BI
  • Use VALUES, SELECTEDVALUE, ALLSELECTED, ALLEXCEPT, ADDCOLUMNS, and SUMMARIZE effectively
  • Create advanced relationship calculations using RELATED, USERELATIONSHIP, CROSSFILTER, and TREATAS
  • Understand iterator functions like AVERAGEX, CONCATENATEX, and RANKX
  • Build reusable date tables and advanced time intelligence calculations
  • Perform YTD, MTD, fiscal period, and parallel period analysis in Power BI
  • Apply DAX best practices and optimization concepts in real-world analytics workflows

Course content

1 section • 63 lectures • 7h 19m total length

  • Introduction to DAX Engines - Part 12:07

    This video provides an introduction to Data Analysis Expression or DAX in Power BI and discusses some of the prerequisites for the course.

  • Introduction to DAX Engines - Part 28:19
  • Introduction to DAX Engines - Part 34:03

    This video provides an understanding of filter flow.

  • Introduction to DAX Engines - Part 412:27

    This video dives into DAX operators, for example, arithmetic and logical operators.

  • Introduction to DAX Engines - Part 54:14

    This video explains DAX engines, which are the formula engine and the storage engine.

  • Introduction to DAX Engines - Part 69:53

    This video explains the two storage engines — VertiPaq engine and DirectQuery.

  • Introduction to DAX Engines - Part 74:15

    This video talks about VertiPaq compression and encoding methodology.

  • Introduction to DAX Engines - Part 86:31

    This video provides a clear idea of hash encoding or dictionary encoding and run length encoding.

  • Introduction to DAX Engines - Part 96:28

    This video explains VertiPaq relationships with the help of an example to help build practical knowledge.

  • Share Your Learning Experience0:53
  • DAX Best Practices - Part 17:23

    This video shows some of the frequently used DAX shortcuts that individuals can utilize to save time.

  • DAX Best Practices - Part 211:21

    This video explains the DAX evaluation order.

  • DAX Best Practices - Part 317:00

    This video shows how to create and utilize DAX variables.

  • DAX Best Practices - Part 47:40

    This video provides detailed knowledge of DAX error handling.

  • Scalar Functions - Part 19:02

    This video explains scalar functions in Power BI and provides a practical understanding of aggregation functions.

  • Scalar Functions - Part 28:35

    This video provides a practical understanding of rounding functions.

  • Scalar Functions - Part 33:39

    This video explains information functions in Power BI.

  • Scalar Functions - Part 44:19

    This video dives into conversion functions, which convert the format of any value’s data type to another format.

  • Scalar Functions - Part 57:00

    This video provides a comprehensive understanding of some basic logical functions.

  • Scalar Functions - Part 67:01

    This video talks about the COALESCE function.

  • Advanced Calculate - Part 16:57

    This video dives into the CALCULATE function.

  • Advanced Calculate - Part 26:58

    This video explains the concept of context transition with regard to calculated columns.

  • Advanced Calculate - Part 314:20

    This video provides a practical understanding of the CALCULATE function’s evaluation order.

  • Advanced Calculate - Part 49:10

    This video explains the CALCULATE modifier with the help of examples.

  • Advanced Calculate - Part 56:42

    This video discusses KEEPFILTERS, which is a CALCULATE modifier.


  • Table & Filter Functions - Part 13:26

    This video dives into table and filter functions.

  • Table & Filter Functions - Part 29:04

    This video provides a clear understanding of calculated tables

  • Table & Filter Functions - Part 39:22

    This video explains the VALUES function.

  • Table & Filter Functions - Part 46:10

    This video dives into the filtering tables category and discusses the SELECTEDVALUE function.

  • Table & Filter Functions - Part 54:27

    This video provides a practical understanding of the ALLEXCEPT function.

  • Table & Filter Functions - Part 64:56

    This video helps explain the ALLSELECTED column.

  • Table & Filter Functions - Part 75:28

    This video dives into table manipulation functions and gives an idea of the SELECTCOLUMN function.

  • Table & Filter Functions - Part 88:45

    This video explains ADDCOLUMNS and SUMMARIZE functions.

  • Table & Filter Functions - Part 99:40

    This video explains the ROW function.

  • Table & Filter Functions - Part 105:33

    This video provides a practical understanding of the table constructor.

  • Calculated Table Joins - Part 17:18

    This video explains calculated table joins.

  • Calculated Table Joins - Part 24:16

    This video explains the UNION function.

  • Calculated Table Joins - Part 34:42

    This video helps build practical knowledge of the EXCEPT function.


  • Relationship Functions - Part 15:13

    This video provides an introduction to relationship functions in Power BI.

  • Relationship Functions - Part 27:12

    This video discusses the RELATED function.

  • Relationship Functions - Part 35:16

    This video talks about the RELATEDTABLE function.

  • Relationship Functions - Part 410:49

    This video explains the USERELATIONSHIP function.

  • Relationship Functions - Part 59:15

    This video explains the CROSSFILTER function with an example.


  • Relationship Functions - Part 610:33

    This video explains the TREATAS function.

  • Iterator Functions - Part 13:24

    This video dives into ITERATOR functions.

  • Iterator Functions - Part 24:11

    This video explains ITERATOR cardinality.

  • Iterator Functions - Part 37:52

    This video provides a practical understanding of the CONCATENATEX function.

  • Iterator Functions - Part 410:05

    This video explains the AVERAGEX function.

  • Iterator Functions - Part 56:09

    This video provides a clear understanding of the RANKX function.

  • Advanced Time Intelligence Functions - Part 17:47

    This video provides an introduction to time Intelligence functions.

  • Advanced Time Intelligence Functions - Part 24:57

    This video explains the date table requirements.

  • Advanced Time Intelligence Functions - Part 34:36

    This video explains the CALENDAR function.

  • Advanced Time Intelligence Functions - Part 47:10

    This video explains the CALENDARAUTO function.

  • Advanced Time Intelligence Functions - Part 56:16

    This video explains how to build a reusable data table.

  • Advanced Time Intelligence Functions - Part 610:09

    This video provides a practical understanding of date formatting.

  • Advanced Time Intelligence Functions - Part 79:01

    This video explains commonly used time intelligence functions.

  • Advanced Time Intelligence Functions - Part 85:39

    This video explains the PREVIOUSQUARTER function.

  • Advanced Time Intelligence Functions - Part 94:14

    This video explains the SAMEPERIODLASTYEAR function.

  • Advanced Time Intelligence Functions - Part 106:01

    This video explains week-based calculations.

  • Advanced Time Intelligence Functions - Part 115:25

    This video explains the process of calculating performance for the previous fiscal week.

  • Advanced Time Intelligence Functions - Part 128:09

    This video explains the DAX pattern that one may utilize to calculate YTD and MTD.

  • Advanced Time Intelligence Functions - Part 139:30

    This video explains how to use the previous year's parallel period functions in the fiscal calendar.

  • Conclusion1:18

Requirements

  • Basic understanding of Microsoft Power BI
  • Familiarity with Power BI reports and data models is helpful
  • No prior advanced DAX knowledge required

Description

Data Analysis Expressions) (DAX) is one of the most powerful and often most challenging components of Microsoft Power BI.

If you want to build advanced calculations, create dynamic reports, optimize data models, and develop professional Power BI dashboards, then mastering DAX is essential.

This course is designed to help you move beyond basic Power BI reporting and develop a deeper understanding of advanced DAX concepts used in real-world analytics and business intelligence workflows.

You’ll learn how DAX engines work, understand filter context and evaluation flow, work with CALCULATE and context transition, build advanced measures, use iterator functions, create calculated tables, and apply advanced time intelligence calculations in Power BI.

The course also covers relationship functions, table manipulation, filter functions, reusable date tables, fiscal calendar calculations, ranking functions, and DAX best practices used by analysts and BI professionals.

Throughout the program, the focus remains on practical understanding and real implementation rather than memorizing formulas.

You’ll work through step-by-step examples designed to help you confidently write, optimize, and understand DAX calculations used in professional Power BI environments.

Whether you are a Power BI user, analyst, reporting professional, dashboard developer, or someone looking to strengthen your business intelligence skills, this course can help you build a strong foundation in advanced DAX concepts and calculations.

Why Take This Course

· Covers advanced DAX concepts step by step

· Focuses on practical implementation instead of only theory

· Includes real-world Power BI calculation workflows

· Explains complex DAX concepts in a structured and simplified way

· Covers advanced time intelligence and relationship calculations

· Includes practical examples for deeper understanding

· Designed for learners who want to move beyond basic Power BI reporting

What Makes This Course Different

  • Focuses specifically on advanced DAX concepts and calculations

  • Explains complex DAX logic in a structured and beginner-friendly manner

  • Covers practical Power BI reporting and analytics workflows

  • Includes advanced topics like context transition, iterator functions, and time intelligence

  • Covers both DAX theory and practical implementation

  • Includes real examples to strengthen conceptual understanding

  • Designed to help learners move beyond basic Power BI reporting

By the End of This Course, You Will Be Able To

  • Write advanced DAX calculations confidently in Power BI

  • Understand filter context, row context, and context transition clearly

  • Build dynamic measures using CALCULATE and advanced DAX functions

  • Create reusable date tables and advanced time intelligence calculations

  • Work with iterator, table, and relationship functions effectively

  • Build more advanced and analytical Power BI reports and dashboards

  • Optimize calculations using structured DAX best practices

  • Apply advanced DAX concepts in real-world reporting and analytics workflows

  • Develop stronger business intelligence and data modeling skills in Power BI

About the Course Director

This course is designed and guided by Dheeraj Vaidya, CFA, FRM, Co-Founder of WallStreetMojo and ExcelMojo, with extensive experience in finance training and professional education.

Dheeraj is an IIT and IIM alumnus and has previously worked with organizations such as JPMorgan and CLSA as an analyst. Over the years, he has helped train more than 100,000 learners through structured and industry-focused finance and analytics training programs.

As the course director, he focuses on creating practical, structured, and application-oriented learning experiences that simplify complex concepts and help learners apply them confidently in real-world business and finance environments.

Who this course is for:

  • Power BI users looking to strengthen DAX skills
  • Data analysts and business intelligence professionals
  • Dashboard developers and reporting professionals
  • Finance and analytics professionals using Power BI
  • Learners who already understand Power BI basics and want to advance further
  • Professionals preparing for advanced Power BI and analytics roles

Report abuse