Calculate trimmed mean in DAX mean RRS feed

  • Question

  • I am very inexperienced when it comes to statistical methods but I need to use one for a model I am working on in PowerPivot. 

    The method I need is TRIMMED MEAN as I need to exclude outliers from an average in the same way as described here:

    I have searched and it appears that Excel has a built-in function for this but DAX does not. What is the best way to do this in PowerPivot?

    Wednesday, November 4, 2015 11:56 AM


All replies