This article presents a method to automatically plug or balance your balance sheet in Power BI. You can use it if your bookkeeping system doesn’t contain the Profit and Loss (PnL) bookings yet. Or for planning or financial modelling purposes when your calculated balance sheet figures don’t add up. The problem to plug or balance … Read more
While Excel and DAX have native functions to calculate the payment amount for a loan, Power Query lacks it still. As this is a very useful function, it’s time to create our own Payment function (PMT) for Power Query: Excel’s payment function (PMT) for Power Query Excel’s PMT function returns the payment for a loan … Read more
While Excel and DAX have native functions to calculate the future value of a payment series, Power Query lacks it still. So it’s time to create our own function for the Future Value (FV) for Power Query: Excel’s function for the Present Value (FV) for Power Query Excel’s FV function returns the future value of … Read more
Finally 2023 is here, the year we expect Power Query function libraries to ship. This will make it so much easier to re-use ready made function than M-extensions. So let’s start collecting some fodder for it, by creating a function to calculate the Present Value (PV) for Power Query: Excel’s Present Value (PV) function for … Read more
Today I’m starting a small series about forecasting in Power BI. In this blogpost I’ll start with a basic example about forecasting with seasonality that I will build upon in the following posts. Please note, that the monthly variation I am using in this example is taken from an existing table and not derived by … Read more
The Black Scholes formula returns the value of European put and call options. The version I’m sharing here uses the standard normal cumulative distribution function from my previous blogpost. Algorithm For the implementation of this formula in M, I’ve used the R implementation from Financetrain for the ease of use: BlackScholes <- function(S, K, r, … Read more