基本函数(5)——Power Query M语言

 

基本函数(5)

表格构成:#table

语法:

#table(columns as any, rows as any) as any

示例:

#table(
  {"列名1", "列名2", "列名3"}, 
  {{值1, 值2, 值3}, {值1, 值2, 值3}, {值1, 值2, 值3}, {值1, 值2, 值3}}
)
=#table(type table[列名1=类型,列名2=类型,列名3=类型], 
  {{值1, 值2, 值3}, {值1, 值2, 值3}, {值1, 值2, 值3}, {值1, 值2, 值3}}
)

 

实例:

空表:
#table({}, {})

 

End

 

posted @ 2022-03-05 08:34  云谷の风  阅读(135)  评论(0编辑  收藏  举报