Please note javascript is required for full website functionality.

Blog

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

17 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 DATE.


A to Z of Excel Functions: The NORMINV Function

16 January 2023

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


Charts and Dashboards: The Risk Bubble Chart – Part 1

13 January 2023

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


Power BI Blog: Datamarts – Part 8

12 January 2023

Welcome back to this week’s edition of the Power BI blog series. This week, we will look at creating reports using the data in a datamart.


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.


Newsletter