Please note javascript is required for full website functionality.

Blog

Power BI Blog: Xenagogue to Markup Lists - Part 3

26 April 2018

Using a multi-row card visualisation to display the USD exchange rate from the RBA RSS feed


Power Query: Hot Cross Joins

25 April 2018

This week I look at cross joins.


Power Pivot Principles: Recognising Measures

24 April 2018

Welcome back to our Power Pivot blog series. Today we discuss how to tell the difference between a measure and a field.


A to Z of Excel Functions: The DAYS360 Function

23 April 2018

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


VBA Blogs: Lost and Found

20 April 2018

It’s easy to get lost in a sea of data, but at times we want to find something in particular, be it a word, number or formula. The Find method in VBA can help us do that!


A to Z of Excel Functions: The DAYS Function

20 April 2018

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


Power BI Blog: Xenagogue to Markup Lists - Part 2

19 April 2018

Using the Power Query Editor to parse through the Reserve Bank of Australia's RSS feed in XML format.


Power Query: Join Me at the Table

18 April 2018

Whilst there are often multiple ways to achieve the same objective in Power Query, the purpose of today’s example is become familiar with the M function, Table.Join.



A to Z of Excel Functions: The DAY Function

16 April 2018

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


Newsletter