用PowerQuery自定義函數(shù)模擬Switch函數(shù)功能
(input) =>
let
values = {
{"zs","張三"},
{"ls","李四"},
{"ww","王五"},
{input,"未找到"}
},
switch = List.First(List.Select(源, each _ {0} = input)){1}
in
swich