Please note javascript is required for full website functionality.

Blog

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

6 February 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 GENERATESERIES.


A to Z of Excel Functions: The PROB Function

5 February 2024

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


Excel for Mac: Power Query features and limitations

2 February 2024

This week in our series about Microsoft Excel for Mac, it’s all about Power Query. For a long time, it didn’t even exist on Mac, but since it’s such a key feature of Excel, the team at Microsoft has been steadily introducing more and more Power Query capability to Excel for Mac. At the time of writing, it’s still missing a few features, but it at least has a good foundation.


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.


Newsletter