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
Posts in Category ‘M’
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: Currently it is not available to analyze “thin reports” in the service du to missing authentication feature. The generation of the token via the Power BI Rest API sites (…) Read more
Power BI Cleaner now fully covers Calculation Groups
Edit 27th June 2021: There is a complete new version of this tool that has all the bugfixes and enhancements here: https://wp.me/p6lgsG-2pi You can now download a new version of (…) Read more
Extract only letters from a mixed string in Power Query and Power BI
This is a quick method about extracting only letters from a string. It is part of the Week2 “Preppin’ data” challenge. Task for extracting letters from a string Image you (…) Read more