Please note javascript is required for full website functionality.
MVP

Blog

Blog

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.


Power Query: Not Your Type

27 November 2019

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


Power Pivot Principles: Understanding functions for parent-child hierarchies in DAX – Part 1

26 November 2019

Welcome back to the Power Pivot Principles blog. Start from this week, we are going to understand some functions for parent-child hierarchies in DAX.


A to Z of Excel Functions: the GAMMA Function

25 November 2019

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


Charts and Dashboards Blog: Chart Design Best Practice – Part 2: Colours and Compositions

22 November 2019

Welcome back to Charts and Dashboards blog series. This week, we are going to look at colour and the variable aspects of a chart.


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

21 November 2019

Welcome back to this week’s Power BI blog series. This week, we are going to look at producing some customised categories for the NSW Food Authority’s register of penalty notices data.


Newsletter