Please note javascript is required for full website functionality.

Blog

Charts and Dashboards: Target Practice

11 June 2021

Welcome back to our Charts and Dashboards blog series. This week, I look at creating a presentation of actual vs. target sales.


Power BI Blog: Monthly New Customers

10 June 2021

Welcome back to this week’s edition of the Power BI blog series. This week, we will look at how to create a simple measure to count the number of new customers in a database for each month.


Power Query: Three Sheets to the Table

9 June 2021

Welcome to our Power Query blog. This week, I look at combining sheets where the columns do not match.


Power Pivot Principles: Calculated Field vs. Measure

8 June 2021

Welcome back to the Power Pivot Principles blog. This week, we consider the differences between creating a calculated field and a calculated measure.


A to Z of Excel Functions: The ISNA Function

7 June 2021

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


Charts and Dashboards: A Bar Chart with Dynamic Ordering – Part 2

4 June 2021

Welcome back to this week’s Charts and Dashboards blog series. This week, we will continue to talk about the bar chart with dynamic ordering.


Power BI Blog: Smart Narratives Now Generally Available

3 June 2021

Welcome back to this week’s edition of the Power BI blog series. This week, we look at Smart Narratives, which are now Generally Available in Power BI Desktop.


Power Query: Evasive Errors

2 June 2021

Welcome to our Power Query blog. This week, I look at a problem I came across when uploading a large dataset from Excel.


Power Pivot Principles: Initial Measures – a Pro Tip

1 June 2021

Welcome back to the Power Pivot Principles blog. This week, we explain the advantages of creating measures from fields. Who’d have thought..?


Monday Morning Mulling: May 2021 Challenge

31 May 2021

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