Please note javascript is required for full website functionality.
MVP

Blog

Blog

Power Query: More Fun with (Un)Pivot

18 December 2019

Welcome to our Power Query blog. This week, I look at another use for unpivoting.


Power Pivot Principles: Introducing the Function LOOKUPVALUE

17 December 2019

Welcome back to the Power Pivot Principles blog. Before we learn more functions for parent-child hierarchies in DAX, this week, we are going to look aside at one function of looking up values in DAX.


A to Z of Excel Functions: the GAMMA.INV Function

16 December 2019

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


Charts and Dashboards Blog: Chart Tools – Contextual Tabs (Part 1)

13 December 2019

Welcome back to Charts and Dashboards blog series. Over the next two weeks, we’ll look at contextual tabs in Chart Tools.


Power BI: Sydney’s Register of Food Penalty Notices – Part 6

12 December 2019

Welcome back to this week’s Power BI blog series. This week, we are going to look at creating our dashboard and applying appropriate formatting.


Power Query: Fun with (Un)PivotTable

11 December 2019

Welcome to our Power Query blog. This week, I look at a use for unpivoting.


Power Pivot Principles: Understanding Functions for Parent-Child Hierarchies in DAX – Part 3

10 December 2019

Welcome back to the Power Pivot Principles blog. This week, we are going to look at another function for parent-child hierarchies in DAX.


A to Z of Excel Functions: the GAMMA.DIST Function

9 December 2019

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


Charts and Dashboards Blog: Chart Design Best Practice – Part 3: Memorable Charts

6 December 2019

Welcome back to Charts and Dashboards blog series. This week, we are going to look at some design concepts to adopt to create memorable charts.


Power BI Blog: New Web Table Inference (Black Friday Special)

5 December 2019

Welcome back to this week’s Power BI blog series. This week, we are going to look at a (relatively) new Preview feature.


Newsletter