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
Posts in Category ‘Power Query’
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
Excel WORKDAY equivalent in Power Query and Power BI
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