Please note javascript is required for full website functionality.

Blog

Power BI Blog: Show Visuals as Tables

7 March 2024

Welcome back to this week’s edition of the Power BI blog series. This week, we look at how to show visuals as Tables.


Power Query: Heading Off – Part 4

6 March 2024

Welcome to our Power Query blog. Today, I continue to consider an issue that occurs when I load to a Table with no headers.


Power Pivot Principles: The A to Z of DAX Functions – HASONEFILTER

5 March 2024

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


A to Z of Excel Functions: The NUMBERSTRING Function

4 March 2024

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


Excel for Mac: Functions Unavailable on Mac

1 March 2024

This week in our series about Microsoft Excel for Mac, we summarise a few worksheet functions that either aren’t supported on Mac or work slightly differently than their counterparts on a PC.


Power BI Blog: Reference Labels

29 February 2024

Welcome back to this week’s edition of the Power BI blog series. This week, we look at the new Reference labels.


Power Query: Heading Off – Part 3

28 February 2024

Welcome to our Power Query blog. Today, I continue looking at an issue that occurs when I load to a Table with no headers.


Power Pivot Principles: The A to Z of DAX Functions – GROUPBY

27 February 2024

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


Monday Morning Mulling: February 2024 Challenge

26 February 2024

On the final Friday of each month, set an Excel for you to puzzle over for the weekend. On the Monday, we publish one suggested solution. No-one is stating this is the best approach, it’s just the one we selected. If you don’t like it, lump it – or contact us with your preferred solution.


Final Friday Fix: February 2024 Challenge

23 February 2024

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.


Newsletter