Please note javascript is required for full website functionality.

Blog

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

19 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 HOUR.


A to Z of Excel Functions: The PROPER Function

18 March 2024

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


Power BI Blog: The Pane Switcher

14 March 2024

Welcome back to this week’s Power BI blog. We will look at the new Ribbon design and the new Pane Switcher together.


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.


Newsletter