Power Query爱好者 – 第 3 页 – 国内首个M语言分享博客

Table.SelectColumns()

Table.SelelctColumns()可以抽象地概括为function(table as table, columns as any, optional missingField as null[......]

Table.ReorderColumns()可以抽象地概括为function(table as table, columnOrder as list, optional missingField as[......]

Table.Profile()可以抽象地概括为function(table as table, optional addtionalAggregates as nullable list) as ta[......]

Table.Sort()可以抽象地概括为function(table as table, comparisonCriteria as any) as table，大概的意思为该函数的第一个参数为需要进[......]

Table.AddJoinColumn()可以抽象地概括为function(table1 as table, key1 as any, table2 as any, key2 as any, newC[......]

Table.AddKey()可以抽象地概括为function(table as table, columns as list, isPrimary as logical) as table，意思为该函[......]

Table.Combine()可以抽象地概括为function(table as list, optional columns as any) as table，意思为该函数的第一个参数为串列，串列中[......]

Table.AggregateTableColumn()可以抽象地概括为function(table as table, column as text, aggregations as list) a[......]

Table.Transpose()可以抽象地概括为function(table as table, optional columns as any) as table，意思为该函数的第一个参数为需要[......]

除了Table.Transpose()与List.Zip()能够完成行列互换，List.TransformMany()也可实现这一动作，不过代码相对没有那么简洁。

如果需要为上表添加行加总与[......]