none
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:

    http://stats.stackexchange.com/questions/16198/what-do-you-call-an-average-that-does-not-include-outliers

    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?

    Thanks. 
    Wednesday, November 4, 2015 11:56 AM

Answers

All replies