M函数目录(Power Query 之 M 语言)

2021-5-29更新

 

主页(选项卡)

  管理列(组)

选取列

转到列Table.SelectColumns:https://www.cnblogs.com/officeplayer/p/13416004.html

删除列

删除列Table.RemoveColumns:https://www.cnblogs.com/officeplayer/p/13377782.html

删除其他列Table.SelectColumns:https://www.cnblogs.com/officeplayer/p/13416004.html

减少行(组)

保留行

保留前面N行Table.FirstN:https://www.cnblogs.com/officeplayer/p/13457407.html

保留后面N行Table.LastN:https://www.cnblogs.com/officeplayer/p/13457484.html

保留中间指定的行Table.Range:https://www.cnblogs.com/officeplayer/p/13510019.html

保留重复行:https://www.cnblogs.com/officeplayer/p/13582504.html

保留错误行Table.SelectRowsWithErrors:https://www.cnblogs.com/officeplayer/p/13944344.html

删除行

删除前面N行Table.Skip:https://www.cnblogs.com/officeplayer/p/13457484.html

删除后面N行Table.RemoveLastN:https://www.cnblogs.com/officeplayer/p/13457407.html

删除间隔行Table.AlternateRows:https://www.cnblogs.com/officeplayer/p/13510083.html

删除重复项Table.Distinct:https://www.cnblogs.com/officeplayer/p/13619364.html

删除空行:https://www.cnblogs.com/officeplayer/p/13696656.html

判断列表是否为空List.IsEmpty:https://www.cnblogs.com/officeplayer/p/13909427.html

用以颠倒黑白Not:https://www.cnblogs.com/officeplayer/p/13909427.html

去除列表中的指定值List.RemoveMatchingItems:https://www.cnblogs.com/officeplayer/p/13873193.html

返回字段值列表Record.FieldValues:https://www.cnblogs.com/officeplayer/p/13696781.html  

删除错误行Table.RemoveRowsWithErrors:https://www.cnblogs.com/officeplayer/p/13944353.html

(筛选)

Table.SelectRows筛选-上:https://www.cnblogs.com/officeplayer/p/13793165.html

Table.SelectRows筛选-下:https://www.cnblogs.com/officeplayer/p/13832074.html

  排序(组)

升序&降序&多级排序:https://www.cnblogs.com/officeplayer/p/13973074.html

转换(组)

  转换函数Table.TransformColumns:https://www.cnblogs.com/officeplayer/p/14400313.html

  拆分列

    按分隔符Table.SplitColumn:https://www.cnblogs.com/officeplayer/p/14159373.html

      拆分函数Splitter.SplitTextByDelimiter:

        https://www.cnblogs.com/officeplayer/p/14092993.html

      拆分函数Splitter.SplitTextByEachDelimiter:

        https://www.cnblogs.com/officeplayer/p/14093054.html

按字符数Table.SplitColumn:https://www.cnblogs.com/officeplayer/p/14192793.html

拆分函数Splitter.SplitTextByRepeatedLengths:

  https://www.cnblogs.com/officeplayer/p/14192706.html

拆分函数Splitter.SplitTextByPositions:

  https://www.cnblogs.com/officeplayer/p/14285666.html

  按位置Table.SplitColumn:https://www.cnblogs.com/officeplayer/p/14285731.html

    拆分函数Splitter.SplitTextByPositions:

      https://www.cnblogs.com/officeplayer/p/14285666.html

  按字母大小写数字非数字等Table.SplitColumn:

    https://www.cnblogs.com/officeplayer/p/14456230.html

    拆分函数Splitter.SplitTextByCharacterTransition:

      https://www.cnblogs.com/officeplayer/p/14456280.html

    判断某值是否在列表中存在List.Contains

      https://www.cnblogs.com/officeplayer/p/14772728.html

  拆分行:https://www.cnblogs.com/officeplayer/p/14400265.html

分组依据:https://www.cnblogs.com/officeplayer/p/14800026.html

设置数据类型:https://www.cnblogs.com/officeplayer/p/14826457.html

提升标题:https://www.cnblogs.com/officeplayer/p/14879176.html

降级标题:https://www.cnblogs.com/officeplayer/p/14903289.html

 

 

其他

Table.AlternateRows和Table.Range:https://www.cnblogs.com/officeplayer/p/13619248.html

 

 

固定结构

each和each _:https://www.cnblogs.com/officeplayer/p/13909427.html

声明函数参数:https://www.cnblogs.com/officeplayer/p/14614161.html

posted @ 2020-08-15 19:42  熬肥妖  阅读(1219)  评论(0编辑  收藏  举报