Please note javascript is required for full website functionality.

Blog

Power BI Blog: Calculating Monthly % Change

13 May 2021

Welcome back to this week’s edition of the Power BI blog series. This week, we will look at how to write a measure to compare the previous month’s collection values to the current month’s collection values.


Power Query: Find a Table

12 May 2021

Welcome to our Power Query blog. This week, I look at what to do when the location of a table is changed.


Power Pivot Principles: PREVIOUSMONTH Comparison

11 May 2021

Welcome back to the Power Pivot Principles blog. This week, we are going to compare monthly data using yet another approach.


A to Z of Excel Functions: The ISERROR Function

10 May 2021

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


Charts and Dashboards: Moving Chart Labels – Part 2

7 May 2021

Welcome back to this week’s Charts and Dashboards blog series. This week, we will continue to discuss about the moving chart labels.


Power BI Blog: Gauge Visualisation – Presenting Percentages

6 May 2021

Welcome back to this week’s edition of the Power BI blog series. This week, we will look at how to use the built-in Gauge visualisation to display percentages.


Power Query: Group Text

5 May 2021

Welcome to our Power Query blog. This week, I look at how to modify a grouping statement to accommodate text fields.


Power Pivot Principles: PARALLELPERIOD Comparison

4 May 2021

Welcome back to the Power Pivot Principles blog. This week, we are going to compare monthly data again, but this time using on an alternative approach.


Monday Morning Mulling: April 2021 Challenge

3 May 2021

This month, we want to check if a pair of values are of the same category.


Challenges: Monday Morning Mulling: April 2021 Challenge

3 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