Please note javascript is required for full website functionality.
MVP

Blog

Blog

A to Z of Excel Functions: the IMARGUMENT Function

13 July 2020

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


Charts and Dashboards Blog: Dynamic Charts – Part 2

10 July 2020

Welcome back to this week’s Charts and Dashboards blog series. This week, we will continue to talk about creating Dynamic Tables using the OFFSET function.


Power BI Blog: The COALESCE Function

9 July 2020

Welcome back to this week’s edition of the Power BI blog series. This week, Jonathan Liau looks at how to use the new COALESCE function.


Power Query: Faster Fiddly Fill Down

8 July 2020

Welcome to our Power Query blog. This week, I look at a more efficient method to solve last week’s fill down problem.


A to Z of Excel Functions: the ARRAYTOTEXT Function

7 July 2020

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


Power Pivot Principles: Introducing the PREVIOUSDAY / MONTH / QUARTER / YEAR Functions

7 July 2020

Welcome back to the Power Pivot Principles blog. This week, we will talk about the group of PREVIOUSDAY / MONTH / QUARTER / YEAR functions in DAX.


A to Z of Excel Functions: the IMAGINARY Function

6 July 2020

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


Charts and Dashboards Blog: Dynamic Charts – Part 1

3 July 2020

Welcome back to this week’s Charts and Dashboards blog series. Over the next few weeks, we’re going to talk about Dynamic Charts. This week, in particular, we will talk about creating Dynamic Tables.


Power BI Blog: Dual Axis Line Chart

2 July 2020

Welcome back to this week’s edition of the Power BI blog series. This week, Jonathan Liau takes a look at some new features for the line visualisation in Power BI.


Power Query: Fiddly Fill Down

1 July 2020

Welcome to our Power Query blog. This week, I look at an example where using the standard fill down will not work and I have to use a conditional column to fill down instead.


Newsletter