Please note javascript is required for full website functionality.

Blog

Final Friday Fix: April 2021 Challenge

30 April 2021

This month, we want to check if a pair of values are of the same category.


Power BI Blog: Revisiting Built-In Gauge Charts

29 April 2021

Welcome back to this week’s edition of the Power BI blog series. This week, Jonathan Liau will look at how to use the built-in Gauge visualisation in Power BI.


Power Query: Arranging a List

28 April 2021

Welcome to our Power Query blog. This week, I look at how to translate a range of data contained in one cell to a list of cells.


Power Pivot Principles: DATEADD Comparison

27 April 2021

Welcome back to the Power Pivot Principles blog. This week, we are going to work on an alternate approach from last week to compare monthly data.


A to Z of Excel Functions: The ISBLANK Function

26 April 2021

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


Charts and Dashboards: Moving Chart Labels – Part 1

23 April 2021

Welcome back to this week’s Charts and Dashboards blog series. This week, we will talk about creating a chart label that can move.


Power BI Blog: Maximum and Minimum Points on a Line Chart

22 April 2021

Welcome back to this week’s edition of the Power BI blog series. This week, Jonathan Liau will build up on last week. He will look at how to plot maximum and minimum points on a line chart.


Power Query: Dating Options

21 April 2021

Welcome to our Power Query blog. This week I look at how to deal with dates in a variety of formats.


Power Pivot Principles: Annual / Monthly Comparisons

20 April 2021

Welcome back to the Power Pivot Principles blog. This week, I will be comparing my Actuals data for different years.


A to Z of Excel Functions: The IRR Function

19 April 2021

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


Newsletter