学习微软新一代Excel Power Query数据处理神器的小伙伴们,
你有没有为写Power Query的M函数痛苦过?
“为毛M函数这么多(500多)!还区分大小!还没有智能感知!
函数啥意思?几个参数?例子有么有?让我怎么写???”
![](https://img.haomeiwen.com/i4132745/e3ab811351f6ff6b.png)
你可能会这么做:
=#shared
![](https://img.haomeiwen.com/i4132745/574decab97dd61ee.png)
或者这么做:
Excel函数模板,
![](https://img.haomeiwen.com/i4132745/b58c47d1110c32c9.png)
再或者,这么做:
查Power Query官方函数说明
![](https://img.haomeiwen.com/i4132745/fa3004b8f98b1ce6.png)
![](https://img.haomeiwen.com/i4132745/bc8f8447a3bbd6b1.png)
能不能更方便点?就像有道词典,屏幕取词?
嘿嘿 PBIHome论坛(PBIHome.net)告诉你,可以滴!GoldenDicts + PBIDicts词库.
![](https://img.haomeiwen.com/i4132745/a756cc3629c9cd31.png)
![](https://img.haomeiwen.com/i4132745/c157800a2fc7ea5c.png)
![](https://img.haomeiwen.com/i4132745/ffdc44b434ac1e0b.png)
![](https://img.haomeiwen.com/i4132745/b0021604c1176f3e.png)
![](https://img.haomeiwen.com/i4132745/067593b0b350ca41.png)
![](https://img.haomeiwen.com/i4132745/25dcae40e0be7115.png)
![](https://img.haomeiwen.com/i4132745/ac2c8d8d5a79083c.png)
![](https://img.haomeiwen.com/i4132745/0ca96f25924bf18f.png)
看到大神的M代码,能不能把涉及的函数都让我学一下?
![](https://img.haomeiwen.com/i4132745/379d4a6fa8407852.png)
![](https://img.haomeiwen.com/i4132745/67dc40be375a9448.png)
更多精彩,尽在PBIHome论坛,小站期待您的加入~~
PBIDicts下载地址:http://pbihome.net/forum.php?mod=viewthread&tid=6&extra=page%3D1
网友评论