Video Library

Month Labels in PowerBI Direct Query Mode

Month label columns are invaluable for things like slicers and report axis. When users see 9 then don't immediately get that you're talking about September, but put a "Sep" on that slicer and things snap into focus pretty quick. But kinda like...

29 March, 2017

Cleaning up 100 column names at one time? List.Zip it good!

List.Zip() is a strange function. It takes a list of lists, and returns a list of lists; so it sounds like it might not do anything. But to the contrary, this is a very useful function that can get you out of...

24 March, 2017

Enabling Disabling multiple measure within a Chart using CONTAINS()

Say a customer wants a line chart with a sales line, a 3 month moving avg, a 6 month moving avg, a 12 month moving average, and a same period last year series. You being a DAX Titan can whip those out...

24 March, 2017

Enable IntelliSense in JavaScript

Some developers rely heavily on intelligent code completion for their development workflow. If you're developing outside of a powerful IDE like Visual Studio, you may only be aware of "smart" code completion. Because JavaScript is loosely typed and many JavaScript developers don't mind monkey patching where...

06 December, 2016

Custom Column Transformations in Power Query

Applying standard transformations to several columns at once is a snap in Power Query. Select all the columns, right click on them, go to transform and pick your pleasure. Boom, done, easy. If you want to do custom transformations though the story is...

20 October, 2016

Transforming Nested Tables in Power Query

Most people are aware that Power Query lets you work with tables that have columns containing other "inner" tables. The classic example is a table representing an Excel workbook where a single column contains several "inner" tables, each representing a sheet. You...

19 October, 2016

R Curious: The Why and How of R in Power BI (Recording)

The addition of the R statistic engine/language to the Power BI platform presents a lot of possibilities for both getting new kinds of data into your model, and displaying information to users in impressive data-dense ways. In the following recording of a presentation...

22 August, 2016

Trailing Date Slicers

This is a cool trick that goes hand in hand with Relative Month Index. It shows how to include a slicer that lets the user choose which month they want to start a 24 month look back in. Users love 12 or...

01 August, 2016

TypeScript Default Parameters and Destructuring As a Substitute for Named Parameters

--VIDEO TRANSCRIPT-- In this video I'll demonstrate how to set default values for function parameters. Some programming languages let you define a function with default parameter values like this: public void AddToCart(string productName, decimal price, int quantity = 1, string currency = "USD") { // logic...

01 August, 2016

Current Month and 2 Months Back Slicers Using Relative Month Index

One of the nice features of Power BI is the ability to select slicer configurations in design mode which are then exposed to the user once they open the report. So if it’s July of 2016, I can select 2016 on a...

27 July, 2016

DAX Table Functions – a short, fast look

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