Replace fixed column names in a function

Hi Thomas_123 

You can update those pieces of code using

Table.Column( ... , ValueColumn )

and

Record.Field ( row, YearColumn) 

The full M code (reformatted slightly) would be:

let
  MyFunction = ( Table as table, NewColumn as text, YearColumn as text, ValueColumn as text, Years_back as number ) =>
    Table.AddColumn(
      Table,
      NewColumn,
      (x) =>
        List.Average(
          Table.Column(
            Table.SelectRows(
              Table,
              (row) =>
                List.Contains(
                  List.MaxN(
                    List.Select(Table.Column(Table, YearColumn), (y) => y <= x{YearColumn}),
                    Years_back
                  ),
                  Record.Field(row, YearColumn)
                )
            ),
            ValueColumn
          )
        )
    )
in
  MyFunction

Does this work for you?