When downloading data from the web, it’s often best to grab the data from APIs that are designed for machine-to-machine communication than from the site that’s actually visible on the (…) Read more
Posts in Category ‘Power BI’
Calculating doubling times with DAX in Power BI
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
Trimming text with custom characters in Power BI and Power Query
When cleaning dirty data, you might have used the Trim-function (Text.TrimStart or Text.TrimEnd) to delete leading or trailing whitespace from your strings. However, did you know that you could use (…) Read more
Date.Networkdays function for Power Query and Power BI
Today I’m going to share my custom NETWORKDAYS function for Power Query with you that uses the same syntax than its Excel-equivalent. NETWORKDAYS function This function’s first 3 parameters work (…) 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
Tidy up Power BI models with the Power BI Cleaner tool
Edit: I am retiring support for this tool for now, as you can find an alternative here: Measure Killer | Brunner BI. Please feel free to use this tool as (…) Read more