In this article I show methods to calculate the doubling time with DAX in Power BI. Doubling time is an indicator used for exponential growth scenarios. It indicates how much (…) Read more
Posts in Category ‘Charting’
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
Universal JSON-opener for Quandl in PowerBI and Excel/Power Query
Today I discovered JSON (…confess) and Quandl. Mates – this is powerful! Here comes just a quick function to automatically expand all columns of a time-series at once:
How to use regular charts on dynamic pivot tables in Excel
There are many good reasons not to use Pivot charts as described in this article i.e. – one I would like to add is the bug when using “invert if negative”: (…) Read more
Visualize query dependencies in Power BI with Sankey diagram
Edit 7th August 2016: You’ll find an easier “OneInAll”-approach in the PowerBI forum here. Thanks to David Moss for reporting an issue with the solution below. PBI-file with new query: (…) Read more
Happy Spreadsheet Day! (Or how to escape Excel-hell)
When reading horror-stories about Excel-hell describing how dangerous it is to use Excel in corporate environments, I cannot help but to think of this hilarious video describing the fatal consequences of acting without (…) Read more