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
Posts in Category ‘M’
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
Power BI Cleaner now fully covers Calculation Groups
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
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
Clean up or harmonize mis- or differently spelled category data with Power Query
A typical problem with data that has been created by manual entries is that category values are often misspelled or missed. So in this article I’m showing a very powerful (…) Read more