Abstract financial background
Article
22nd Aug 2018
4
In his latest Power Query editor tutorial, Simon Hurst tackles the grouping option that allows you to generate a summary table from a...
spreadsheet
Article
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
Article
27th Mar 2018
1
Simon Hurst looks at advanced merges in Power Query, including joins that involve more than a single field and approximate lookups, using...
spreadsheet data
Article
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...