PowerQuery: How can I use a list item for referring to a table column?-CodePudding

I have a list with the column names of a table. I want to refer to the table's column with the name of the first item in my ColumnNameList. (The background is that I want to create a function, which transforms each column by deviding it by a columnspecific factor.)

I thought it must be

= MyTable[ColumnNameList{0}]

but this doesn't work.

= ColumnNameList{0}

and

= MyTable[SpecificColumnName]

both works. ColumnNameList{0} gives me a Specific column name and if I put a specific column name in MyTable it gives me the column I want. Why does it not work together?

CodePudding user response：

= MyTable[ColumnNameList{0}]

should be

= Table.Column(MyTable,ColumnNameList{0})