DAX

JEFFREY WANG (Microsoft Power BI)   Jeffrey will go over important DAX concepts, programming patterns, debugging techniques, and common user mistakes. DAX has been repeatedly voted by users as one of the most powerful features of Power BI and at the same time one...

RACHEL DYER (CSG Pro)   Rachel Dyer is the Vice President of Analytics at CSG Pro with in-depth expertise of the Microsoft BI stack and dimensional modeling. She has a broad management background and strong communications skills, coupled with considerable technical experience in platform...

BRIAN GRANT (CSG Pro)   In this presentation local DAX obsessive Brian Grant will show you how to use a CSG built Dial sparkline measure to quickly display goal to actual information in a highly compressed manner that will be an excellent addition to...

Creating and troubleshooting time intelligence measures in Power BI can be tricky work. Getting a measure to work at one granularity is hard enough, but when you start to look at rollup values it's difficult to be confident that you're getting the...

Getting a percent of total measure working in DAX, understanding how it's working in a non vague way can be quite a bit trickier. Really it is an ideal pattern to learn some of the underlying behavior of DAX. In this video, we...

When learning DAX, time intelligence formulas are an excellent place to start, and of the many formula patterns out there, “Year to Date” variations might be the best to learn first. The problem is, while writing them is fairly easy, understanding how...

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?