Please note javascript is required for full website functionality.

Blog

Power Query: Folding Table

19 May 2021

Welcome to our Power Query blog. This week, I look at Query Folding.


Power Pivot Principles: PREVIOUSQUARTER Comparison

18 May 2021

Welcome back to the Power Pivot Principles blog. This week, we are going to compare quarterly data using a new Power Pivot function.


A to Z of Excel Functions: The ISEVEN Function

17 May 2021

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


Charts and Dashboards: Chart Titles as a Text Box

14 May 2021

Welcome back to this week’s Charts and Dashboards blog series. This week, we will talk about creating a chart title using a text box.


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.


Newsletter