Video Library

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

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

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

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

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

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

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?