Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
Have you considered letting the data model do the work for you?
Probably, it's consuming too much memory resource to merge the two tables. Thanks for help