Please note javascript is required for full website functionality.

Blog

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.


Power Pivot Principles: Parameter Table

25 February 2020

Welcome back to the Power Pivot Principles blog. This week, we are going to learn a way to introduce a parameter table into Power Pivot.


A to Z of Excel Functions: The GESTEP Function

24 February 2020

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


A to Z of Excel Functions: The INDIRECT Function

22 February 2020

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


Charts and Dashboards: Radar Charts

21 February 2020

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


Power BI Blog: Custom Visuals – the Hierarchy Tree Continued

20 February 2020

Welcome back to this week’s Power BI blog series. This week, Jonathan Liau takes a deeper look at the Hierarchical Variance Tree visualisation.


Newsletter