Power BI – Advanced Analytics with DAX (2026)

In this Bigger Brains course, you’ll build on your existing Power BI skills and take your data analysis capabilities to the next level with advanced Data Analysis Expressions (DAX). Designed for intermediate Power BI users, you should already be familiar with data modeling and DAX expressions before taking this course. This course shows you how to use advanced DAX functions and techniques to enhance data models, streamline calculations, and create more insightful reports. You’ll learn how to use VAR and RETURN statements to simplify complex formulas, create reusable expressions, and improve measure performance. You’ll also learn how functions such as TREATAS, USERELATIONSHIP, and RELATED help you work with filter context and model relationships more effectively.

You’ll explore how DAX can make reports more dynamic, interactive, and visually impactful. You’ll see how to create conditional formatting rules using IF and SWITCH, build DAX expressions that drive custom formatting, and develop dynamic report titles with SELECTEDVALUE and CONCATENATEX. You’ll also learn how to create informative tooltips that provide additional context and insights for report consumers. By the end of this course, you’ll be able to apply advanced DAX techniques to build more efficient, insightful, and engaging Power BI reports that support better business decision-making.

Topics covered include:

• Explain the purpose of VAR and RETURN in DAX
• Use variables to define reusable expressions and simplify complex calculations
• Apply variables in conditional logic
• Use TREATAS to apply filter context from one table to another
• Apply USERELATIONSHIP to activate alternative relationships in specific measures
• Use RELATED to navigate relationships from one table to another
• Apply conditional formatting on two outcomes using IF
• Create multi-tiered formatting rules using SWITCH
• Use SELECTEDVALUE and CONCATENATEX to create dynamic titles
• Create Tooltips with DAX

Enjoy award winning HD content in the “Uniquely Engaging”TM Bigger Brains Teacher-Learner style! Taught by top subject matter experts, Bigger Brains courses are professionally designed around key learning objectives and include captions and transcripts, downloadable handouts, and optional LinkedIn digital badges on course completion.