Please note javascript is required for full website functionality.


August 2017 Updates for Get & Transform / Power Query Add-In

24 August 2017

We are suspecting these are beginning to taper off now, as the updates are becoming progressively more difficult to find and they are not being summarised in such detail (if the laws of grammar allow you to do such a thing!).

Anyway, Microsoft has just released another set of transformation updates for Get & Transform. The pick of this month’s bunch has to be Suggestions, which is the latest enhancement to the recently released ‘Add Column From Examples’ feature, which can be accessed via the ‘Add Column’ tab on the Query Editor Ribbon.

It’s really quite useful for the inexperienced. As users go into ‘Add Column From Examples’, the software will show suggestions for output values based on the contents of other columns and partial contents typed by the user. In particular, if readers read through the suggestions, they will easily be able to distinguish between multiple transformations where the output value might be the same for a given row – and improve their skills at the same time!

There’s also a raft of new transformations, including Number, Date, Time and Timezone operations. We will list them all in our September newsletter. If you are not already a subscriber, simply enter your details at the bottom of any SumProduct web page and you’ll get yours very shortly.

These updates are available as part of an Office 365 subscription. If you are an Office 365 subscriber, you can find out how to get these latest updates here. If you have Excel 2010 or Excel 2013, you can also take advantage of these updates by downloading the latest Power Query for Excel add-in.