If you want to transform your Excel calculations over to Power Query you might appreciate functions there that have the same syntax like in Excel itself. Today I’m going to (…) Read more
Transforming multiple columns at once with reference to existing column in Power Query
In this article I’m going to present a method about transforming multiple columns at once in a fast way. This method also allows you to reference columns that exist in (…) Read more
Excel NORM.INV function in Power Query and Power BI
The Excel NORM.INV function hasn’t made it into the standard library of M functions for Power Query yet. So here I’m sharing a custom function that replicates it. Excel NORM.INV (…) Read more
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
Excel NORM.DIST function in Power Query and Power BI
If you’re looking for Excel functions in Power BI, you will recognize that much more of them have been transformed to native DAX functions than to native M functions in (…) Read more
Power BI Cleaner Gen2 now covers Analysis Services Models as well
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