DAX Optimization: Where To Find The Hidden DAX Trap
I want to focus today on something I call the hidden DAX trap. If you encounter this situation, it will make you feel like you’re losing your mind because your DAX is going to look right, but it’s not going to work. I’ll walk you through when that occurs and what you can do about […]
The post DAX Optimization: Where To Find The Hidden DAX Trap first appeared on Master Data Skills + AI.
Published on:
Learn moreRelated posts
This Tool Builds Your Power BI Backgrounds FOR YOU!
Optimising DAX: The Formula Engine and Storage Engine
When you execute a DAX query, two engines divide up the work. Understanding the split between the formula engine and the storage engine is key...
How Microsoft Fabric, Azure, and Power BI Are Transforming Analytics
Introduction Data has become one of the most valuable assets for modern organisations. However, collecting data alone is no longer enough—busi...
Agentic AI in Power BI and Fabric, Part 4: From Skills to an Agentic Report Theme Audit Workflow
In Part 1, I went through the concepts and terminology behind agentic AI, things like agents, tools, skills, MCP, guardrails, and Human i...
Analysing Power BI Data Using Copilot In Excel
This week there was another big Copilot-related announcement for Power BI – but on the Excel blog. You can now analyse data from Power B...
Excel or Power BI: Why Start Over?
Power BI, M365 Copilot And The Importance Of DAX UDFs
This was a big week for Power BI Copilot with the announcement of a new direction for the feature. If you haven’t done so already, read ...