Calculate a Change in Values - Omitting Errors

Hi liamcameron ,

"I'm attempting to create a table that will show the average usage of an engine over a month. "

Do you want to exclude the wrong hours and then average it over a month?

As shown in the table below, 16 is an incorrect value, so you need to exclude it and then average it, right?

But there is a question here, based on what do we judge whether this value is wrong or correct?

And is this what you want?

average usage of an engine = 
AVERAGEX(
    FILTER(
        Range,
        [Hours] >= 10000 && [Hours] <= 12000
    ),
    [Hours]
) 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.