Please note javascript is required for full website functionality.

Blog

Charts and Dashboards: Surface Charts

8 July 2022

Welcome back to our Charts and Dashboards blog series. This week, I look at surface charts.


Power BI Blog: Data Hub

7 July 2022

Welcome back to this week’s edition of the Power BI blog series. This week, we look at the Data Hub.


Power Query: Keeping it Current – Part 1

6 July 2022

Welcome to our Power Query blog. This week, I copy a query to the workbook data has been extracted from.


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

5 July 2022

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 CONTAINSROW.


A to Z of Excel Functions: The MMULT Function

4 July 2022

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


Charts and Dashboards: Data Tables - Part 5

1 July 2022

Welcome back to our Charts and Dashboards blog series. This week, we’re going to cover how to create Data Tables on different sheets than the inputs that they’re referring to.


Power BI Blog: Power BI Metrics

30 June 2022

Welcome back to this week’s edition of the Power BI blog series. This week, we look at The Artist Formerly Known As Goals.


Power Query: See it, Save it, Sort it - Part 7

29 June 2022

Welcome to our Power Query blog. This week, I refine my grouping and show how to preserve data order while grouping.


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

28 June 2022

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 CONTAINS.


Monday Morning Mulling: June 2022 Challenge

27 June 2022

On the final Friday of each month, we set an Excel / Power Pivot / Power Query / Power BI problem for you to puzzle over for the weekend. On the Monday, we publish a solution. If you think there is an alternative answer, feel free to email us. We’ll feel free to ignore you.


Newsletter