Please note javascript is required for full website functionality.
MVP

Blog

Blog

Power Query: Group Dynamics

10 October 2018

Welcome to our Power Query blog. This week, I look at how to calculate a group share.


Power Pivot Principles: Importance of Contiguous Dates

9 October 2018

Welcome back to our Power Pivot blog. Today, we discuss why it is important to have Contiguous Dates in a calendar table.


A to Z of Excel Functions: the DPRODUCT Function

8 October 2018

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


VBA Blog: Going Through the Visual Basics – Part 8

5 October 2018

We thought we’d run an elementary series going through the rudiments of Visual Basic for Applications (VBA) as a springboard for newer users. This blog looks at the concept of a variable scope at a module level.


Power BI: Visting Ideas

4 October 2018

Last week, we had a training session where someone suggested a great idea for an improvement to Power BI. That gave us a great idea – October is going to be Ideas month for our Power BI blog!


Power Query: Let It Be

3 October 2018

Welcome to our Power Query blog. This week, I look at (some of the most) simple M statements.


Power Pivot Principles: Introducing the CLOSINGBALANCEMONTH Function

2 October 2018

Welcome back to our Power Pivot blog. Today, we introduce the CLOSINGBALANCEMONTH function.


Monday Morning Mulling: September 2018 Challenge

1 October 2018

Welcome to this month’s Monday Morning Mulling! Last week, we set a challenge that has stumped project finance specialists worldwide – how do you set up an upfront or establishment fee for a debt facility, in a way that updates automatically and doesn’t require a...


Final Friday Fix: September 2018 Challenge

28 September 2018

Welcome to this month’s Final Friday Fix! This month we’re going to delve into the world of project finance, and in particular, look at the issue of construction funding – in particular, the problem of what to do when there is an upfront cost based on some total...


Power BI – M Intellisense

27 September 2018

As we promised in our recent newsletter, we’ll be spending the next couple of months talking about some of the new Power BI features that are being rolled out.


Newsletter