Please note javascript is required for full website functionality.
MVP

Blog

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...


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.


Charts and Dashboards Blog: 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.


Power Query: Next (Row) Again Please

19 February 2020

Welcome to our Power Query blog. This week, I look at another solution to last week’s problem referencing other rows.


Newsletter