Please note javascript is required for full website functionality.

Blog

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.


Power Query: Project Population – Part 13

19 July 2023

Welcome to our Power Query blog. This week, I create a query by extracting rows in Data that have no matches in Country.


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

18 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 EDATE.


A to Z of Excel Functions: The PERCENTILE Function

17 July 2023

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


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

14 July 2023

Welcome back to our Charts and Dashboards blog series. This week, we’re going to look at how to make a bespoke Point and Figure chart.


Power BI Blog: RANK and ROWNUMBER (New DAX Functions)

13 July 2023

Welcome back to this week’s edition of the Power BI blog series. This week, we inspect two new DAX functions, RANK and ROWNUMBER.


Power Query: Project Population – Part 12

12 July 2023

Welcome to our Power Query blog. This week, I solve the formatting issue in my merged query and apply some buffering.


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

11 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 EARLIEST.


Newsletter