Video Library

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

Read More »

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

Read More »

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

Read More »

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

Read More »

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: <span class="hljs-function"><span class="hljs-keyword">public</span> <span class="hljs-keyword">void</span> <span class="hljs-title">AddToCart</span>(<span class="hljs-params"><span class="hljs-keyword">string</span> productName, <span class="hljs-keyword">decimal</span> price,

Read More »

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

Read More »
Stay Connected

Subscribe to CSG Pro. We’ll supply your inbox with the latest blog posts, training videos, and upcoming events.


Ready to wrangle your data?