Please note javascript is required for full website functionality.
MVP

Blog

Blog

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 Blog: 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.


Charts and Dashboards Blog: Dynamic Legend

16 April 2021

Welcome back to this week’s Charts and Dashboards blog series. This week, we will talk about how to create a dynamic legend.


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

15 April 2021

Welcome back to this week’s edition of the Power BI blog series. This week, Jonathan Liau will look at how to create maximum and minimum lines on a line chart.


Power Query: Key Facts

14 April 2021

Welcome to our Power Query blog. This week, I look at some shortcuts to use in Power BI Transform Data.


Newsletter