XLSouth Sydney 7/8 March – 35% Discount

Ken Puls has kindly offered a special 35% discount (first 5 registrations only) for the upcoming XLSouth Sydney Conference next week. The conference is 2 days and features global Excel MVP/Experts talking on one of my favourite topics – Microsoft Excel The Sydney Conference is on Mon 7/Tues 8 March. […]

Read More »

Combine Excel Workbooks with Power Query – Method 2

Edit: Feb 2017.  Microsoft has released an update that solves the problem described in this article.  This article still has learning value however you should also take a look at the announcement from Microsoft here https://blogs.office.com/2017/02/08/january-2017-updates-for-get-transform-in-excel-2016-and-the-power-query-add-in/ There are many ways to combine data from multiple files into a single file/table in […]

Read More »

Control Cross Filtering of Charts in Power BI

The team at Power BI is setting a blistering pace of updates and improvements for PowerBI.com and Power BI Desktop.  One of the great improvements in the November 2015 update is the ability to control how cross filtering between charts (and other objects) on the canvas works.  The default cross […]

Read More »