Please note javascript is required for full website functionality.

Blog

Excel for Mac: Introduction – A New Series

8 December 2023

This is the first in our new blog series, all about Microsoft Excel for Mac. In each post, we’ll cover a different topic to help you understand how Excel for Mac is different to Excel for Windows. But hey, let’s get introductions out of the way first!


Power BI Blog: Model Explorer in Preview Part 2

7 December 2023

Welcome back to this week’s edition of the Power BI blog series. This week, we look at how to add new calculation items to calculation groups and create relationships with the Model explorer now in Preview.


Power Query: Blog List – Part 2

6 December 2023

Welcome to our Power Query blog. I would like to get a list of all the Power Query blogs I have posted. Today, I extend the query to extract data from all pages.


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

5 December 2023

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


A to Z of Excel Functions: The GROUPBY Function

4 December 2023

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


Charts and Dashboards: The Horizontal Raincloud Chart – Part 4

1 December 2023

Welcome back to our Charts and Dashboards blog series. This week, we continue to show you how to make a bespoke Horizontal Raincloud chart, by merging the charts created so far to create the final Horizontal Raincloud chart.


Power BI Blog: Model Explorer in Preview Part 1

30 November 2023

Welcome back to this week’s edition of the Power BI blog series. This week, we look at how to create calculation groups using the Model explorer now in Preview.


Power Query: Blog List – Part 1

29 November 2023

Welcome to our Power Query blog. I would like to get a list of all the Power Query blogs I have posted. Today, I begin by extracting data from the first page.


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

28 November 2023

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


Monday Morning Mulling: November 2023 Challenge

27 November 2023

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