Forum Discussion
Calculate the average
Good morning. On my spreadsheet I have in the same column a part number and the Working hours to replace that specific part number: Follow an example Job Number Part Number Qty 1...
Thanks for the answer! I reckon is more complicated than that. I use just one part number example, but imagine a spreadsheet with more than 5000 lines. With more than 1000 parts numbers listed.
What I want to do is to create a way where I search for the specific part number to check the average time to replaced. So I will be able to track with our mechanics specifics jobs and the "whys" for some jobs took longer than others.
I created one measure to find the average, but when I search for the part number return Blancked:
Average = AVERAGEX(FILTER(claim_export,claim_export[article_numbers] = "1111118"),claim_export[quantity])