用PowerQuery自定义函数模拟Switch函数功能

用PowerQuery自定义函数模拟Switch函数功能

(input) =>
let
    values = {
            {"zs","张三"},
            {"ls","李四"},
            {"ww","王五"},
            {input,"未找到"}
          },
    switch = List.First(List.Select(源, each _ {0} = input)){1}
in
    swich