Please note javascript is required for full website functionality.

Blog

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

7 August 2023

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


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

4 August 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 prepare data to transform the chart data.


Power BI Blog: Power BI Desktop with Files in OneDrive and SharePoint

3 August 2023

Welcome back to this week’s edition of the Power BI blog series. This week, we look at the wonderful world of Power BI Desktop, OneDrive and SharePoint.


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.


Newsletter