DAX

You've built a simple "Sum for All Categories" measure that is so darn simple that it's impossible for it not to work; but alas it does not. If the category column you were trying to remove from the filter context had a...

If you've got a large number of columns on a table to transform it can be quite a hassle. Here we'll show a way to use List. Transform along with some code fishing techniques to whip up a solution to convert a...

Understanding Context Transition can be super frustrating for a new Power BI user. Definitions for it seem deceptively simple, but wrapping your head around how it actually works within a DAX expression can be painfully difficult. Fear not though my fellow DAXciples,...

If you want to understand DAX, sooner or later you’re going to have to deep dive into Table Functions. The SQL BI guys Marco Russo and Alberto Ferrari train people in Table Functions before CALCULATE. And for good reason. If I’ve learned anything about DAX,...

Ready to wrangle your data?