calculate cycle times, get an average excluding top 15%

[DFlynn]

In a manufacturing setting I have a pick started and pick completed time/date stamps, i have subtracted them from one another to get the duration or cycle time. I am trying to build a report to get the average which i did using a measure however my data is skewed due to some outlier times and i would like to exclude the top 15% without removing the data. I know i can do it with if functions within excel but i am racking my brain with DAX.

[Greg_Deckler · Accepted solution]

@DFlynn Try using AVERAGX with a FILTER function. For a more complex approach to this, here is an equivalent of TRIMMEAN in Excel: TRIMMEAN - Microsoft Power BI Community

[DFlynn]

That did work but did not quite give me the result i wanted, I ended up using power query to duplicate the start and end times columns and then turning those into decimal value. Take that and split the column at the delimiter, seperating the time and the date sets. Then i can subtract them accurately because DAX is odd with times over 24hours. Did the averages from that and converted it all back over. Thank you for the assistance.