Please note javascript is required for full website functionality.

Blog

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.


Power BI Blog: Button Slicers

22 February 2024

Welcome back to this week’s edition of the Power BI blog series. This week, we review a new visual: Button slicers.


Power Query: Heading Off – Part 2

21 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 – GEOMEANX

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


A to Z of Excel Functions: The ECMA.CEILING Function

19 February 2024

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


Excel for Mac: Power Query and PivotTables – Consolidate Ranges

16 February 2024

This week in our series about Microsoft Excel for Mac, we show you a better way to create a PivotTable with data from several ranges, sometimes called a Consolidated Range PivotTable.


Power BI Blog: Suggested Synonyms from Copilot

15 February 2024

Welcome back to this week’s edition of the Power BI blog series. This week, we look at Copilot sticking its oar in and suggesting synonyms.


Newsletter