Please note javascript is required for full website functionality.
MVP

Blog

Blog

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.


Power Query: The Wrong Type

4 December 2019

Welcome to our Power Query blog. This week, I look at a problem when assigning data types to columns.


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

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


Monday Morning Mulling: November 2019 Challenge

2 December 2019

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

29 November 2019

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


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

28 November 2019

Welcome back to this week’s Power BI blog series. This week, we are going to look at creating more custom categories that simplify current data.


Newsletter