Please note javascript is required for full website functionality.

Blog

Power Query: Heading Off – Part 5

13 March 2024

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


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

12 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 HASONEVALUE.


A to Z of Excel Functions: The PRODUCT Function

11 March 2024

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


Excel for Mac: Mac Only - Customise Your Keyboard Shortcuts

8 March 2024

This week in our series about Microsoft Excel for Mac, we show how to customise your keyboard shortcuts using both Excel’s built-in ‘Customize Keyboard’ feature or Mac’s keyboard shortcut preferences. This is one of the things you can do with Excel for Mac that you can’t do on Windows.


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.


Newsletter