Please note javascript is required for full website functionality.

Blog

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, we take 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.


Power Pivot Principles: Bidirectional Relationships in Power Pivot

18 February 2020

Welcome back to the Power Pivot Principles blog. This week, we are going to talk about relationships in Power Pivot.There are three different possible physical relationship types in database design but not all supported in Power Pivot. The major types of relationship...


A to Z of Excel Functions: The INDEX Function

15 February 2020

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


Charts and Dashboards: Scatter Charts

14 February 2020

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


Newsletter