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...

24 April, 2019

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...

23 January, 2019

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...

26 September, 2018

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...

22 August, 2018

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...

11 August, 2018

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...

10 August, 2018

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...

15 March, 2018

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...

15 March, 2018

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,...

10 August, 2017

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,...

15 July, 2016

Ready to wrangle your data?