Advanced DAX for Power BI-Course Overview

An advanced DAX course typically covers a wide range of topics, including time-intelligence functions, advanced filtering techniques, custom aggregation functions, optimization techniques, and working with advanced data modeling techniques such as bidirectional relationships, virtual tables, and hierarchies. The course may also include hands-on exercises and Case Studies to help participants apply their learning to real-world scenarios. The following are the major topics in the course:

Time intelligence: Time intelligence is crucial to data analysis, especially when dealing with business data. The training will explore advanced DAX techniques for time-related calculations, such as calculating year-to-date, comparing periods, and working with custom date hierarchies.

Complex Data Modeling: Explore strategies to handle complex data models with multiple tables, including managing relationships, working with hierarchies, and implementing advanced data modeling techniques.

Advanced Filtering: Dive into advanced filtering techniques using DAX, including the use of CALCULATE, CALCULATETABLE, and other functions to create dynamic and context-aware calculations.

Advanced Visualization Techniques: Learn how to leverage advanced DAX calculations to create visually impactful and interactive Power BI visualizations and reports.

You’ll learn advanced data modeling techniques using DAX, including working with complex relationships, handling many-to-many relationships, implementing role-playing dimensions, and optimizing data models for improved performance.

Overall, an advanced DAX course helps to improve their data analysis and modeling skills and use DAX more effectively for complex calculations and visualizations.

Upcoming Batches

Enroll Online
Start Date End Date

To be Decided

Key Features

  • Advanced DAX course will cover a wide range of advanced DAX functions and formulas, allowing you to manipulate and analyze data in more sophisticated ways.
  • This may include functions like CALCULATE, CALCULATETABLE, FILTER, SUMMARIZE, ALL, TOPN, and many others. Our certified instructors bring expertise and industry experience to DAX.
  • The training will likely include real-world use cases and examples to demonstrate how advanced DAX techniques can be applied to solve complex data analysis problems. This will help you understand how to leverage DAX effectively in practical scenarios.
  • To reinforce your learning, the course may include hands-on exercises and projects where you can apply the concepts you've learned. This will allow you to practice building advanced DAX calculations and data models.

Who can participate in the Microsoft Power BI Data Analyst Certification Training?

  • The advanced DAX (Data Analysis Expressions) course is designed for individuals who have a basic understanding of DAX and want to take their skills to the next level. This course is ideal for:
  • Business analysts: Those who work with data regularly and want to improve their analytical skills.
  • Data analysts: Those who want to learn how to use DAX to create complex calculations and analyze data more effectively.
  • Power BI developers: Those who want to create more complex models and calculations in Power BI.
  • Excel users: Those who use Excel for data analysis and want to learn how to use DAX to create more complex formulas and calculations.
  • Overall, the advanced DAX course is best suited for individuals who have experience working with data and are looking to expand their skill set in this area.

What are the prerequisites for the Advanced DAX course?

  • Understanding of Basic DAX syntax: Participants should be familiar with basic DAX functions and operators, including CALCULATE, FILTER, and SUMX.
  • Understanding of Data modelling: Participants should have experience with data modelling concepts, such as relationships between tables and creating calculated columns and measures.
  • Power BI or Excel: Participants should be familiar with either Power BI or Excel, as these tools are commonly used in conjunction with DAX.

What makes CloudThat a compelling choice for PL-300 training for Microsoft Power BI Data Analysts?

  • With over 11 years of experience in training and consulting, we at CloudThat bring extensive expertise to deliver training based on the client’s requirements and PL-300 training for Microsoft Power BI Data Analysts.
  • CloudThat has successfully trained a vast number of professionals, approximately 6.5 lakh individuals, and provided training services to more than 100 corporate clients across the globe.
  • Our Microsoft certified trainers (MCTs) for PL 300 Power BI Data Analyst course emphasize a significant portion of hands-on lab sessions, ranging from 50% to 60%, to foster a learning approach centered around scenario-based problem-solving.
  • CloudThat offers training and consulting services with a proven track record of successfully delivering numerous projects, including engagements with Fortune 500 companies.
  • CloudThat has established itself as a Microsoft Partner, as well as partnering with other renowned industry leaders such as AWS, GCP, and VMWare

Learning Objectives of Advanced DAX:

  • Mastery of Advanced DAX Functions: Gain a comprehensive understanding of advanced DAX functions and their usage, including complex functions like CALCULATE, CALCULATETABLE, FILTER, SUMMARIZE, ALL, TOPN, RANKX, and many others. Learn how to leverage these functions effectively to manipulate and analyze data.
  • Advanced Time Intelligence: Develop expertise in handling time-related calculations and analysis using DAX. Understand advanced techniques for calculating year-to-date, comparing periods, handling multiple calendars or fiscal years, and creating custom date hierarchies for more sophisticated time-based analysis.
  • Advanced-Data Modeling Techniques: Learn advanced data modeling concepts and techniques to design efficient and flexible data models. Explore topics such as managing complex relationships, resolving many-to-many relationships, implementing role-playing dimensions, and optimizing data models for improved performance.
  • Advanced Calculation Scenarios: Dive into advanced calculation scenarios that go beyond basic aggregation. Learn how to create dynamic measures, handle conditional logic, work with hierarchical data structures, and implement advanced calculations for complex business requirements.

Course Outline Download Course Outline

  • Different types of DAX data types
  • Working with calculated columns and calculated measures
  • Understanding the DAX engine, Vertipaq Engine
  • Best Practices to start DAX.

Aggregation functions:

  • Working with aggregation functions such as: • Count • Sum • Average • Minimum, or Maximum

Table functions:

  • Intro to table functions
  • Filtering a table with Filter functions and ignoring filters
  • Working with ALLSELECTED and RELATEDTABLE functions
  • Tables and Relationships
  • Using Table Variables for the complex requirements

Iterator functions:

  • Introduction to Iterator functions
  • Working with Iterator functions like MINX and MAXX
  • Useful Iterators to work with tables and measures.
  • Understanding the functions like ISINSCOPE and RANKX

Time Intelligence Functions:

  • Introduction to Time Intelligence functions
  • What are different time intelligence functions, common usage of those functions.
  • Working with functions like DATEADD, DATESINPERIOD
  • Understanding the concepts of Running totals, Semi-Additive measures.

  • Introduction to Evaluation Context
  • Working with Evaluation context on Filtered context, Row Context, and Context Errors.
  • Evaluation context and their relationships

  • Introduction to CALCULATE function.
  • Using filter context inside the calculate function.
  • Understanding the KEEPFILTER context inside the Calculate function.
  • Advanced evaluation context using DAX.
  • USERELATIONSHIP function usage in CALCULATE function to work with inactive relationships.
  • Using ALL function for filter context inside the CALCULATE function.
  • Using the ALLSELECTED function for filter context inside the CALCULATE function.
  • Using the KEEPFILTERS function for filter context inside the CALCULATE function.
  • Understand the concept of circular dependency.

  • Introduction to Hierarchies
  • Understand the concept of Parent-Child Hierarchies
  • Working with FILTER and CROSSFILTER

  • Introduction to Querying in DAX
  • Working with tables and Queries
  • Working with functions for querying like EVALUATE, CALCULATETABE, SELECTCOLUMNS, SUMMARIZE, CROSSJOIN, TOPN and GENERATE, ROW and DATETABLE.
  • Understanding the querying with measures UNION, INTERSECT, and EXCEPT

  • Understand the Ambiguity of Many-to-Many relationships in Power BI.
  • How to handle many-to-many relationships
  • Bidirectional Filtering in the modelling and work with them.

  • Working with data at different granularity
  • Using TREATAS
  • Working with Calculate Tables and slice dimensions.
  • Leveraging the Week relationships

Course Fee

Select Course date

Can't See the Date? Contact Us to Enroll and Get More Information

Add to Wishlist

Course ID: 15758

Course Price at

$1601 + 0% TAX
Enroll Now

Frequently Asked Questions

This course is designed for Power BI users and professionals who are already familiar with the basics of DAX and want to take their skills to the next level.

Participants should have a solid understanding of the fundamentals of Power BI and be comfortable working with DAX formulas and functions.

This course will cover advanced DAX techniques and concepts, including advanced calculations, time intelligence, handling complex data models, working with multiple tables, advanced filtering, optimization, and performance tuning. Participants will also learn best practices for efficient data modeling and analysis.

This course will include hands-on exercises and examples to reinforce the concepts discussed. Candidates can practice and apply the advanced DAX techniques in real-world scenarios.

Participants will have access to course materials, including code samples, and exercises. Any necessary datasets and Power BI files required for the exercises will also be provided.

The course duration may vary, but it typically ranges from one to three days, depending on the depth of coverage and the specific requirements. Depending on the chosen learning method, the course can be offered in both self-paced and instructor-led formats.

While this course focuses on using advanced DAX techniques in Power BI, many of the concepts and principles covered can be applied to other data analysis tools that support DAX, such as Excel Power Pivot and Analysis Services Tabular models.

Enquire Now