Please note javascript is required for full website functionality.

Blog

Charts and Dashboards: Stock Charts

20 March 2020

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


Power BI Blog: Power BI Report Builder – Part 2

19 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 create reporting tables in the Power BI Report Builder.


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: 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 GETPIVOTDATA Function

9 March 2020

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


Newsletter