Please note javascript is required for full website functionality.

Blog

Final Friday Fix: May 2025 Challenge

30 May 2025

On the final Friday of each month, we set an Excel / Power Pivot / Power Query / Power BI problem for you to puzzle over for the weekend. On the Monday, we publish a solution. If you think there is an alternative answer, feel free to email us. We’ll feel free to ignore you.


Power BI Blog: Style Presets to Visuals

29 May 2025

Welcome back to this week’s edition of the Power BI blog series. This week, we ask whether your visuals have sufficient style…


Power Query: Split Folder Part 9

28 May 2025

Welcome to our Power Query blog. This week, I look at how I can convert a parameter extracted from the workbook into a Power Query parameter.


Power Pivot Principles: The A to Z of DAX Functions – INFO.TABLES

27 May 2025

In our long-established Power Pivot Principles articles, we continue our series on the A to Z of Data Analysis eXpression (DAX) functions. This week, we look at INFO.TABLES.


A to Z of Excel Functions: The SERIESSUM function

26 May 2025

Welcome back to our regular A to Z of Excel Functions blog. Today we look at the SERIESSUM function.


AI Blog: ChatGPT 4.5 – Where AI Starts to Feel Human Part 1

23 May 2025

Welcome back to our weekly AI blog. Today, we start exploring the new model released by ChatGPT, GPT-4.5.


Power BI Blog: Semantic Version Model History

22 May 2025

Welcome back to this week’s edition of the Power BI blog series. This week, we look at version history in semantic models.


Power Query: Split Folder Part 8

21 May 2025

Welcome to our Power Query blog. This week, I examine the difference between the types of parameters I have been using.


Power Pivot Principles: The A to Z of DAX Functions – INFO.STORAGETABLES

20 May 2025

In our long-established Power Pivot Principles articles, we continue our series on the A to Z of Data Analysis eXpression (DAX) functions. This week, we look at INFO.STORAGETABLES.


A to Z of Excel Functions: The SERIES function

19 May 2025

Welcome back to our regular A to Z of Excel Functions blog. Today we look at the SERIES function.


Newsletter