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 (…) Read more
Posts in Category ‘Accounting’
Black Scholes Option Pricing with Power Query in Power BI
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 (…) Read more
Dynamic Benford’s Law measures in Power BI and Power Pivot
Benford’s Law compares the frequency distribution of leading digits to its (empirically proven) natural counterpart. This can then be used to detect fraud and errors. The green columns show how (…) Read more
Parent-Child Hierarchies with multiple parents in Power BI with Power Query
I’ve written about a method to dynamically flatten parent-child-hierarchies also with multiple parents some while ago here. I’ve actually used this approach for Bill-of-materials cases and refined that approach in (…) Read more
Automatically validate E-mail attachments with Flow and Power BI
Receiving files from business partners that don’t match the agreed requirements/formats causes all sorts of problems in daily business. I found it particularly disturbing during month-end closing when time is (…) Read more
Get full Time Activity data from QuickBooks into Power BI
Problem As per the time of writing, the native QuickBooks connector in Power BI has some shortcomings for the Time Activity-data: It will not return employee details (so you will (…) Read more