根据变量列名选择行

Question

这似乎并不困难，但我在这里很累。我想通过变量名引用表列进行筛选，但无法理解为什么这不起作用。

let
Source = Table.FromRecords({
[VarColumn = "Val",  Phone = "123-4567"],
[VarColumn = "Val2",  Phone = "987-6543"],
[VarColumn = "NA",  Phone = "543-7890"],
[VarColumn = "OTHER",  Phone = "543-7890"]
}),
VariableColumn = "VarColumn",
filter = Table.SelectRows(Source, each (Table.Column(Source, VariableColumn) = "OTHER"))
in
filter

Answer 1

尝试

filter = Table.SelectRows(Source, each Record.Field(_, VariableColumn) = "OTHER")