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.

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.

Welcome to our Power Query blog. This week, I look at how to deal with imported errors.

Welcome back to our Power Pivot blog. Today, we go over how to refresh data in Power Pivot.

Welcome back to our regular A to Z of Excel Functions blog. Today we look at the DOLLARFR 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 declaring variables.