Use variables as column names in List Selects

[lipesouza12]

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

KPI	COMERCIAL	ACTIVE
SALES KPI	4010922	2683778
SERVICES KPI	44002	2944251
RENEW KPI	241812	1618
MONETIZE KPI	43693	29236
AMOUNT	4340429	5658883

An table PERFORMANCE

SELLER	GROUP	KPI
PATRICIA	COMERCIAL
CELIA	COMERCIAL
LUCIANA	ACTIVE
HELEN	ACTIVE
ANA	COMERCIAL
AURELIO	COMERCIAL

[lbendlin]

Have you considered letting the data model do the work for you?

[lipesouza12]

Probably, it's consuming too much memory resource to merge the two tables. Thanks for help