DAX

Power BI Dashboard in a Day - 11/19/18

By CSG Pro on 10/16/2018

Microsoft in partnership with CSG Pro are pleased to offer a 1-day workshop covering the capabilities of Power BI. The goal of this informational session is to help you understand how to analyze your data in a rich and compelling way.

Power BI Dashboard in a Day - 10/25/18

By CSG Pro on 9/17/2018

Microsoft in partnership with CSG Pro are pleased to offer a 1-day workshop covering the capabilities of Power BI. The goal of this informational session is to help you understand how to analyze your data in a rich and compelling way.

Building a DAX Time Intelligence Inspector

By Brian Grant on 8/22/2018

In this video we'll be building a time intelligence inspector that will let us peer inside any of our time intelligence measure and for our constructed tables, show us the first and last date, as well as the number of days it has. This will enable us to quickly spot check the values in our matrix to see if the days our measure is considering match up to the time intelligence question being asked.

DAX Percent of Total: A Visual Walkthrough

By Brian Grant on 8/11/2018

In this video, we take a very simple percent of total measure and let you poke behind the curtain to see what's happening internally at each step of evaluation. If you're new to DAX or you've been doing it for a while but feel your understanding is very cursory this video may help snap a lot of things into focus for you.

DAX Year to Date: A Visual Walkthrough

By Brian Grant on 8/10/2018

In this video, we take a simple YTD measure with a very simple model and walk through what's happening behind the scenes step by step so you can get a more solid understanding of how it works, which will help you understand how DAX works in general. We go through some tricky DAX concepts, but because they are laid out in front of you, they can become much easier to understand and then learn.

Transform Multiple Columns at Once in M

By Brian Grant on 3/15/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 huge number of columns all at once without too much fanfare and only a single step in your code.

Power BI User Group - August Meetup

By CSG Pro on 8/15/2017

Join us for the last monthly Power BI meetup in our Pearl District location! Our very own Rachel Dyer, Brian Grant and Jamie Mikami will be sharing their expertise on design principles, DAX, and the new Power BI API!

Context Transition in DAX/Power BI: A Visual Guide

By Brian Grant on 8/10/2017

Context Transition can be frustrating for a new Power BI user. Definitions for it seem deceptively simple, but wrapping your head around how it works within a DAX expression can be quite difficult. Fear not though, in this video we're going to walk you through the step by step mechanics of how the Context Transition behavior of CALCULATE() can take a sad broken formula and almost magically bring