Please note javascript is required for full website functionality.

Blog

ChatGPT Final Fiday Fix Explanation

1 February 2024

On the final Friday of each month, we release a blog series called the “Final Friday Fix” where we set an Excel / Power Pivot / Power Query / Power BI problem for users to solve over the weekend. This month, we decided to experiment by creating the Final Friday Fix and its corresponding Monday Morning Mulling using the new ‘GPTs’ feature in ChatGPT. Here is how we did it and how we also reflect on how well it went.


Power BI Blog: Highlight Event Periods – Part 2

1 February 2024

Welcome back to this week’s edition of the Power BI blog series. This week, we will complete building the combo visual that highlights event periods.


Power Query: Equal Split Part 4

31 January 2024

Welcome to our Power Query blog. Today, I modify the solution to divide amounts over rows by using a parameter.


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

30 January 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 GENERATEALL.


Monday Morning Mulling: January 2024 Challenge

29 January 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.


Final Friday Fix: January 2024 Challenge

26 January 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: Highlight Event Periods – Part 1

25 January 2024

Welcome back to this week’s edition of the Power BI blog series. This week, we will show you how to label periods on a visual.


Power Query: Equal Split Part 3

24 January 2024

Welcome to our Power Query blog. Today, I look at a slightly different problem where I need to divide amounts over rows.


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

23 January 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 GENERATE.


A to Z of Excel Functions: The PRICEMAT Function

22 January 2024

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


Newsletter