While Power Query provides a convenient method to fill values from selected columns up- and downwards, there is no native option to do this to the right or left. So (…) Read more
Posts Tagged ‘Function’
TRIMMEAN function for Power Query and Power BI
TRIMMEAN is a statistical function in Excel that calculates the “mean taken by excluding a percentage of data points from the top and bottom tails of a data set”. So (…) Read more
Excel WEEKNUM function for Power Query
If you are looking for the Excel equivalent of the WEEKNUM function for Power Query this article is for you. As this is also a function that has many regional (…) Read more
Excel YEARFRAC function for Power Query
While there is a native YEARFRAC-function in DAX that you can use to calculate year fractions, sometimes you might just need it in Power Query. The function I’m presenting here (…) 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
Improve File Import from SharePoint in Power BI and Power Query
When you use the UI to import files from SharePoint, you’ll end up with the Sharepoint.Files function. This function can become fairly or super slow when you use it on (…) Read more