Please note javascript is required for full website functionality.

Blog

Final Friday Fix: March 2024 Challenge

29 March 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: Visual Calculations in Preview

28 March 2024

Welcome back to this week’s edition of the Power BI blog series. This week, we look at the new Preview feature in Power BI, visual calculations.


Power Query: Heading Off – Part 7

27 March 2024

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


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

26 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 IF.


A to Z of Excel Functions: The PV Function

25 March 2024

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


Excel for Mac: Keyboard Shortcuts on a Small Keyboard

22 March 2024

This week in our series about Microsoft Excel for Mac, we provide a list of keyboard shortcuts that are very helpful to know, especially if you’re using the keyboard on a MacBook.


Power BI Blog: Storytelling in PowerPoint

21 March 2024

Welcome back to this week’s edition of the Power BI blog series. This week, we look at the Power BI add-in for PowerPoint.


Power Query: Heading Off – Part 6

20 March 2024

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


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.


Newsletter