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).

For those clients and / or readers in the UK, SumProduct’s very own Liam Bastick is to be a contestant on the legendary quiz show, Countdown.

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...

The August release has another hotly anticipated feature from the Microsoft Business Application Summit: grouping.  Grouping in reports, similar to PowerPoint’s grouping, lets you easily organise groups of visuals to move and resize them as a set.  This month’s...

Two-thirds of the way through the year and the rate of change in Power BI and Service continues.

After a six-year hiatus, we are pleased to announce SumProduct has managed a return visit to Microsoft’s Excel Blog.

Announcing a public Preview of the ‘new look’ for Power BI Service.

With this month’s update comes the first feature release from Microsoft’s recent announcements at the Microsoft Business Application Summit (MBAS): icon sets.

Announcing the latest updates for Power BI Service and Mobile.

SumProduct is pleased to announce that two of our Directors have been re-awarded Microsoft’s Most Valuable Professional (MVP) award for Excel.