Same calculations on multiple columns

Ashish_MathurThanks Ashish, I was actually able to solve the problem by pivoting the table in the following way. And then working with rows instead of columns.

Index FIFO2 Value

Changing the DAX to:

AverageBetween400and440 = 
  CALCULATE(
    AVERAGE('Table'[Value]),
    'Table'[Index] >= 15 && 'Table'[Index] <= 20
  )


transformed_FIFI2 =  [AverageBetween400and440] - SUM('Table'[Value])


Avg Last 10 Max = 
  var maxV = MAX('Table'[Value])
  var maxI = CALCULATE(MAX('Table'[Index]), 'Table'[Value] = maxV)  
  RETURN
    CALCULATE(
      AVERAGE('Table'[Value]),
      'Table'[Index] > maxI - 10 && 'Table'[Index] <= maxI 
    )