Forum Discussion

lipesouza12's avatar
lipesouza12
Frequent Visitor
4 years ago
Solved

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 th...
Need Help
Show and Tell
Tips and Tricks
  • v-kkf-msft's avatar
    v-kkf-msft
    4 years ago

    Hi lipesouza12 ,

     

    Please try the following code.

     

    =
let 
  a = [GROUP]
in 
  Record.Field(GOALS{List.PositionOf(GOALS[KPI], "AMOUNT")}, a)

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

So it sounds like you were trying to attach the column to each row of the Performance Table, so and if statement would work:

 

Table.AddColumn(PriorStep, "KPI", each if [Group] = "COMMERCIAL" then Goals[COMMERCIAL] else Goals[Active])

 

make sure you use UPPPERCASE anywhere I got the case wrong.

 

--Nate

  • lipesouza12's avatar
    lipesouza12
    Frequent Visitor
    4 years ago

    Hi Anonymous 

     

    Thanks for help. Unfortunately the IF statement isn't appropriate as GROUP types can be created posteriorly forcing a code change each.