Please note javascript is required for full website functionality.

Blog

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

15 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 ENDOFYEAR.


A to Z of Excel Functions: The PERCENTRANK Function

14 August 2023

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


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.


Newsletter