DAX - Beyond the Basics

❓ Have you been using PowerBI for a while but your users are now asking for more complex measures and reports?

❓ Would you like to step beyond these simple reports and take your DAX to the next level to solve your organisation’s challenges?

❓Are you comfortable with basic DAX and CALCULATE, but:

Seeking solutions to complex business problems using DAX.

Working in industries like finance, sales, supply chain, or analytics, where advanced calculations are essential.

Your DAX is limited and you end up with solutions that don’t perform.

You solve problems by duplicating and precalculating data – which is slow to iterate on – rather than in DAX.

You are looking forward to review several DAX concepts with practical applications you can easily reuse.

You want more DAX tools in your DAX toolbox to help you excel.

Overview

This workshop will advance your DAX skills to bridge the gap between basic and advanced concepts. Through real-world scenarios, you’ll learn to write efficient expressions, solve complex business challenges, and create dynamic, impactful reports with DAX.

Here are a few examples of what you can learn in this workshop:

✅Using OR conditions between slicers in DAX.
✅Creating a slicer that filters multiple columns in Power BI.
✅ Learn how to use REMOVEFILTER / VALUES for “natural” hierarchical calculations.
✅Show updated year-to-date actuals and forecasts in the same chart.
✅When and how to use visual calculations in DAX.
✅Optimize cumulative totals using variables and windows.
✅Implement different types of ranking calculations.
✅Aggregate relative periods (like each new customer's first 30 days of purchase) efficiently.

By the end of this session, attendees will be able to: ✅Implement patterns in DAX and model design to solve practical business problems ✅Learn and practice advanced DAX concepts like data lineage ✅Adopt best practices in solving business problems with Power BI