Please note javascript is required for full website functionality.

Blog

Power Query: Join or List - Part 7

11 January 2023

Welcome to our Power Query blog. This week, I continue comparing alternative approaches to extracting data from another table with approximate matching using List() functions.


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

10 January 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 DATATABLE.


A to Z of Excel Functions: The NORMDIST Function

9 January 2023

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


Charts and Dashboards: Vertical Raincloud Chart Part 4

6 January 2023

Welcome back to our Charts and Dashboards blog series. This week, we’re going to continue looking at how to make a bespoke Vertical Raincloud chart by combining the three charts we have created.


Power BI Blog: Datamarts – Part 7

5 January 2023

Welcome back to this week’s edition of the Power BI blog series. This week, we will create our own query within a datamart.


Power Query: Join or List - Part 6

4 January 2023

Welcome to our Power Query blog. This week, I continue to continue comparing alternative approaches to extracting data from another table with approximate matching using List() functions.


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

3 January 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 CUSTOMDATA.


A to Z of Excel Functions: The NORM.S.INV Function

2 January 2023

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


Charts and Dashboards: Vertical Raincloud Chart Part 3

30 December 2022

Welcome back to our Charts and Dashboards blog series. This week, we’re going to continue looking at how to make a bespoke Vertical Raincloud chart by creating the last of three charts that we will need.


Power BI Blog: Datamarts – Part 6

29 December 2022

Welcome back to this week’s edition of the Power BI blog series. This week, we will look at the options to refresh for datamarts.


Newsletter