Please note javascript is required for full website functionality.
MVP

Blog

Blog

Power Query: Reorganising by Numbers

18 March 2020

Welcome to our Power Query blog. This week, I look at using some numerical functions to sort out expense formatting.


Power Pivot Principles: Using ADDCOLUMNS to Create a Calendar Table

17 March 2020

Welcome back to the Power Pivot Principles blog. This week, we are going to learn a way of using a DAX function to create a calendar table.


A to Z of Excel Functions: the HARMEAN Function

16 March 2020

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


Charts and Dashboards Blog: Treemap Charts

13 March 2020

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


Power BI Blog: Power BI Report Builder – Part 1 (Importing Data)

12 March 2020

Welcome back to this week’s edition of the Power BI blog series. This week, Jonathan Liau takes a look at how to import data into the Microsoft Power BI Report Builder.


Power Query: Empty

11 March 2020

Welcome to our Power Query blog. This week, I look at how to achieve the opposite of fill up / down.


Power Pivot Principles: Ambiguity of Bidirectional Relationships in Power BI

10 March 2020

Welcome back to the Power Pivot Principles blog. This week, we are going to talk about the ambiguity of bidirectional relationships in Power BI.


A to Z of Excel Functions: the GROWTH Function

9 March 2020

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


Charts and Dashboards Blog: Sunburst Charts

6 March 2020

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


Power BI: Impact Bubble Chart

5 March 2020

Welcome back to this week’s Power BI blog series. This week, Jonathan Liau looks at how to use the Impact Bubble Chart.


Newsletter