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
Posts in Category ‘Accounting’
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
Export data from Power BI to csv using Python
In this blogpost I show you my M-Python-function that I use to export data from Power BI to csv files (Export Python). Why Python? I prefer it to R mostly (…) Read more
Why Power BI isn’t suitable for Financial Statements (… currently … hopefully …)
!! This is a clickbait post to get your vote for some missing features in Power BI !! Although this might not be what the inventors of Power BI had (…) Read more