Today, Microsoft has announced the first step towards full support for Power Query in Excel for Mac.

It’s not every month that this comes out, but this release is packed with many reporting features to make up for the regularity of updates.

The Artist Formerly Known as Power Query – Get & Transform – is having a bit of a makeover, with some useful new features added to the View tab of the Power Query Editor, viz.

It’s 12 months since Microsoft rocked the calculation boat with its new range of dynamic array functions and features. Those of us lucky enough to get it in Excel Insider Fast raved incessantly. But what’s actually happened one year later..? We take a look.

One month we are going to sit here and write, “nope, nothing happened this month”. But it’s not going to be this month. There are still more updates for Power BI Mobile and Service.

Power BI Desktop received a makeover this month with its new, default theme!

It is now believed – although not officially confirmed – that XLOOKUP and XMATCH have now been rolled out to all Office 365 Insider Fast users.

Power BI Mobile provides the tools you need to stay connected to your data, wherever you may be. However, as organisations grow, it becomes increasingly difficult for Power BI users to discover and manage the content that matters to them on the go. Microsoft has indeed recognised that users must be able to find exactly what they need quickly and easily when they’re using the Power BI Mobile app to view and interact with their content.

Late August 2019 and Microsoft has added two new functions, XLOOKUP and XMATCH. For reasons that will become clear, here I will mainly consider the former function – because once you understand XLOOKUP, XMATCH becomes obvious (nothing personal, XMATCH).

There’s a new Power BI book out – but it’s not like a normal book used to learn Power BI. This book is a selection of articles from 21 Power BI MVPs, including our very own Liam Bastick. Each chapter focuses on a particular subject instead, rather than provide a...