Please note javascript is required for full website functionality.
MVP

Blog

Blog

Power Query: Even More Fun with (Un)Pivot

25 December 2019

Welcome to our Power Query blog. This week, I look at another example of unpivoting.


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

24 December 2019

Welcome back to the Power Pivot Principles blog. This week, we are going to look at an example of applying functions for parent-child hierarchies in a business case.


A to Z of Excel Functions: the GAMMADIST Function

23 December 2019

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


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

20 December 2019

Welcome back to Charts and Dashboards blog series. This week, we’ll continue to look at the Format sub-tab from the contextual Chart Tools tabs.


Power BI Blog: Creating a Dynamic Calendar Table

19 December 2019

Welcome back to this week’s Power BI blog series. This week, we are going to look at how to create a dynamic calendar table in Power BI.


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.


Newsletter