For many Excel users diving into Power BI, the biggest roadblock isn’t the formula syntax, it’s the mindset shift. DAX doesn’t follow the cell-by-cell logic we’re used to. And no function captures that better (or confuses us more) than CALCULATE.

When I first learned DAX through Rob Collie’s Power Pivot and Power BI, I made the classic mistake: treating CALCULATE like a turbocharged SUMIFS. That worked—until it didn’t. And once I understood why, everything changed.

In this session, I’ll break down how I explain the core concepts of DAX—especially to Excel pros—and why reframing your thinking is key to mastering it. If you've ever felt like DAX makes no sense, this talk is for you.

45 minute session focussed on upskilling Excel and Power BI users to change the way they approach DAX