October is Ideas month for our Power BI blog!

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

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

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

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.

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!

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

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

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 macro to run it or to switch on iterative calculations?

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 financed amount.