Please note javascript is required for full website functionality.

Blog

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

11 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 all the data we have summary, prepare and transform to plot the chart.


Power BI Blog: New DAX Function MATCHBY

10 August 2023

Welcome back to this week’s edition of the Power BI blog series. This week, we look at a new DAX function available in Power BI: MATCHBY.


Power Query: Power Query Online – Part 1

9 August 2023

Welcome to our Power Query blog. Today, I look at the functionality available in Power Query Online, available during dataflow creation in Power Apps.


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

8 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 ENDOFQUARTER.


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.


Newsletter