Please note javascript is required for full website functionality.

Blog

Power Query: Power Query Online – Part 2

16 August 2023

Welcome to our Power Query blog. Today, I look at some of the settings in Power Query Online.


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.


Newsletter