Please note javascript is required for full website functionality.


June 2024 Updates for Power BI

13 June 2024

Amongst other announcements, you can now download large semantic models, there is a Power BI enhanced report format (PBIR) and there is also now Subfolder support in Power BI Report Builder...

New Features for Excel May 2024

29 May 2024

It’s a little quieter on the Excel front this month, but I suppose it’s more about quality than quantity. This month sees two key announcements...

Regex comes to Excel

22 May 2024

Today sees the release of three [3] new Excel functions to the Beta versions of Excel...

May 2024 Updates for Power BI

22 May 2024

This month’s updates see new On-object Interaction updates, DAX query view now Generally Available, and you can find out how to view reports in OneDrive and SharePoint with live connected semantic models...

Revision to PIVOTBY

16 May 2024

Back in November last year, Microsoft announced several new functions, including PIVOTBY, and eta lambdas such as PERCENTOF. On the quiet, they have added a new argument which makes PIVOTBY just that little bit more powerful...

New Features for Excel April 2024

1 May 2024

Generating multiple formula columns, creating complex formula columns that span across multiple tables and new ways to engage with Copilot in Excel are now all available to Excel users on web and Windows (subject to roll out)...

April 2024 Updates for Power BI

10 April 2024

This month’s updates see line enhancements, supporting folders in workspace, dynamic subscriptions for Power BI and paginated reports, amongst other newbies.

March 2024 Updates for Power BI

27 March 2024

Another busy month for Power BI (just for a change!). There are new updates for Visual calculations, editing your data model in the Power BI Service, and deliver report subscriptions to OneDrive SharePoint.

New Features for Excel March 2024

26 March 2024

This month sees Export to CSV and Show Details in PivotTables are now available in Excel for the web. Also, creating Power BI-connected tables is available in Excel for Windows users, together Office Scripts for Office 365 E1 and F3 licenses.

Steve Kraynak MVP

1 March 2024

Fantastic news for Leap Day: we are very pleased to announce US head honcho Steve Kraynak has been awarded Microsoft’s Most Valuable Professional (MVP) award for Excel.