Power Query techniques

In this series Simon Hurst examines some of the Power BI techniques in more depth in order to understand what they are capable of, and how best to use them, not only when working with external data, but also for changing the way that we work within Excel workbooks.

Abstract financial background
22nd Aug 2018
In his latest Power Query editor tutorial, Simon Hurst tackles the grouping option that allows you to generate a summary table from a...
12th Jul 2018
Simon Hurst looks at conditional columns and the Power Query equivalent of the well-known IF() function. IF() is one of the most frequently...
Abstract numeric data
27th Mar 2018
Simon Hurst looks at advanced merges in Power Query, including joins that involve more than a single field and approximate lookups, using...
spreadsheet data
14th Feb 2018
Over the past few months we have looked at the range of BI tools included as part of Excel or in the separate Power BI Desktop application...