Please note javascript is required for full website functionality.

Blog

Power Query: Fabulously Fiddly Fill Down

15 July 2020

Welcome to our Power Query blog. This week, I again look at the fill down problem I have considered for the past two weeks this time using a column copy solution.


Power Pivot Principles: Introducing the FILTER Function

14 July 2020

Welcome back to the Power Pivot Principles blog. This week, we will talk about the FILTER function in DAX.


A to Z of Excel Functions: The ARRAYTOTEXT Function

13 July 2020

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


A to Z of Excel Functions: The IMCONJUGATE Function

13 July 2020

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


Charts and Dashboards: 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, we look 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.


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.


A to Z of Excel Functions: The IMARGUMENT Function

6 July 2020

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


Newsletter