Forum Discussion
Andrew_lu1933
4 years agoRegular Visitor
How to set var to select column name?
in power query, if I want to operate one column, we will use _[columnName]. but if I want operate many column, I want use List.Transform({columnName1, columaname2},(t)=> operate(Table, [t]). how t...
Anonymous
4 years agoNot applicable
You can try
each (row)=> List.Tranform({row[Column1], row[Column2]}=> operate(Table, [t]))
--Nate
- Andrew_lu19334 years agoRegular Visitor
[t] , the t is only as a str, not as a var.