Please note javascript is required for full website functionality.

Blog

A to Z of Excel Functions: The GETPIVOTDATA Function

9 March 2020

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


A to Z of Excel Functions: The GROWTH Function

9 March 2020

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


Charts and Dashboards: Sunburst Charts

6 March 2020

Welcome back to this week’s Charts and Dashboards blog series. This week, let’s look at Sunburst Charts.


Power BI Blog: Impact Bubble Chart

5 March 2020

Welcome back to this week’s Power BI blog series. This week, Jonathan Liau looks at how to use the Impact Bubble Chart.


Power Query: Dynamic Removals

4 March 2020

Welcome to our Power Query blog. This week, I look at how to remove columns without referencing column names.


Power Pivot Principles: Introducing the Function CROSSFILTER

3 March 2020

Welcome back to the Power Pivot Principles blog. This week, we are going to learn a new DAX function, CROSSFILTER.


Monday Morning Mulling: February 2020 Challenge

2 March 2020

On the final Friday of each month, we set an Excel problem for you to puzzle over 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.


Final Friday Fix: February 2020 Challenge

28 February 2020

On the final Friday of each month, we’re going to set an Excel / Power BI challenge for you to puzzle over so that you can get your “Excel / Power BI fix”. Challenge your office colleagues to see who can solve the puzzle quickest. There are no prizes at this stage: you’re playing for bragging rights only!


Power BI Blog: Custom Visuals – the Hierarchy Tree Advanced Editor

27 February 2020

Welcome back to this week’s Power BI blog series. This week, Jonathan Liau takes an even deeper look at the Hierarchy Tree visualisation.


Power Query: Next (Row) Once Again Please

26 February 2020

Welcome to our Power Query blog. This week, I look at yet another solution to my “February problem” referencing other rows.


Newsletter