Please note javascript is required for full website functionality.

Blog

Final Friday Fix: April 2024 Challenge

26 April 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: Editing Your Data Model in Power BI Service

25 April 2024

Welcome back to this week’s edition of the Power BI blog series. This week, we look at some of the latest updates made in assisting you edit your data model in Power BI Service.


Power Query: Revision Time – Part 3

24 April 2024

Welcome to our Power Query blog. Today, I continue to create a refreshable revision timetable by calculating the number of slots available.


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

23 April 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 INDEX.


A to Z of Excel Functions: The QUARTILE.EXC Function

22 April 2024

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


Excel for Mac: Optimised AutoRecover (Only on Mac)

19 April 2024

This week in our series about Microsoft Excel for Mac, we tell you how to protect yourself from losing work in case Excel crashes or is forced to quit without saving your work.


Power BI Blog: Autocreating a Mobile Layout

18 April 2024

Welcome back to this week’s edition of the Power BI blog series. This week, we look at how simple it is to automatically create mobile optimised reports.


Power Query: Revision Time – Part 2

17 April 2024

Welcome to our Power Query blog. Today, I continue to create a refreshable revision timetable by calculating the number of subjects to be studied.


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

16 April 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 IGNORE.


A to Z of Excel Functions: The QUARTILE Function

15 April 2024

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


Newsletter