Forum Discussion

liamcameron's avatar
liamcameron
New Member
6 years ago

Calculate a Change in Values - Omitting Errors

I have Engine hours being recorded every day across many engines across a fleet of vehicles. Occasionally the hours are put in incorrectly. I'm attempting to create a table that will show the average...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

Create a new column like given below

Column = if(Range[Hours]/AVERAGEX(Range,Range[Hours])>.85 && Range[Hours]/AVERAGEX(Range,Range[Hours]) <=1.15,1,0)

 

You can change the range of valid values depeand on need. Now take Min and max by excluding 0.

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin

liamcameron's avatar
liamcameron
New Member
6 years ago

So to do a sales analogy... pretend that is my net revenue for a year, but what it was on day 1, day 2. So it's always increasing. the [hours] column is a total. i'm trying to find what was the average change, but excluding those errors