Please note javascript is required for full website functionality.

Blog

Power Pivot Principles: Using SELECTCOLUMNS to Create Calendar Table

24 March 2020

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


A to Z of Excel Functions: The HEX2BIN Function

23 March 2020

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


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, we 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, we 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.


Newsletter