Please note javascript is required for full website functionality.

Blog

Power Query: Template Tease

2 August 2023

Welcome to our Power Query blog. Today, I take a sneak peek at a feature that is currently only available on the ‘Office Insider’ program.


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

1 August 2023

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 ENDOFMONTH.


Monday Morning Mulling: July 2023 Challenge

31 July 2023

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: July 2023 Challenge

28 July 2023

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: Azure Maps

27 July 2023

Welcome back to this week’s edition of the Power BI blog series. This week, we look at the Azure Maps visualisation.


Power Query: Project Population – Part 14

26 July 2023

Welcome to our Power Query blog. This week, I complete the Project Population series.


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

25 July 2023

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 EFFECT.


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

24 July 2023

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


Charts and Dashboards: The Point and Figure Chart – Part 2

21 July 2023

Welcome back to our Charts and Dashboards blog series. This week, we continue to explain how to create a bespoke Point and Figure chart by looking at how we use the summary data to prepare the chart data.


Power BI Blog: Optimizing the Ribbon

20 July 2023

Welcome back to this week’s edition of the Power BI blog series. This week, we look at the Optimize tab on the Ribbon.


Newsletter