Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
lipesouza12
Frequent Visitor

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

KPICOMERCIALACTIVE
SALES KPI40109222683778
SERVICES KPI440022944251
RENEW KPI2418121618
MONETIZE KPI4369329236
AMOUNT43404295658883

 

An table PERFORMANCE

SELLERGROUPKPI
PATRICIA COMERCIAL 
CELIA COMERCIAL 
LUCIANA ACTIVE 
HELEN ACTIVE 
ANA COMERCIAL 
AURELIO COMERCIAL 

 

2 REPLIES 2
lbendlin
Super User
Super User

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors