Use variables as column names in List Selects

Hi Community,

Today I'm stuck on a simple list selection. I need to load the KPI from another table according to the group the salesperson belongs to. One possibility would be an IF statement but the groups may vary, in this case I would like to select the Goals Table Column from the group the seller belongs to. I tried declaring a variable and calling it as column but it didn't work.

let  Group = [GROUP] in
    Goals & Group{List.PositionOf(Goals[KPI], "AMOUNT")}

And Tried

let  Group = [GROUP] in
    Goals{List.PositionOf(Goals[KPI], "AMOUNT")}Group

But both return me Expression.SyntaxError: Expected token Eof. Another problem, is the dimension of the table that exceeds the thousands of rows

heres the table sample GOALS

An table PERFORMANCE