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...
is this what you want?
Column = if('Table'[Part Number]="9001",AVERAGEX(FILTER('Table','Table'[Part Number]="118"),'Table'[Qty]),'Table'[Qty])