weixin_44500833的博客

题目：将表1、表2导入到PQ中：完整代码：let 源 = Table.AddColumn(表1, "Mail Type", each List.Last(表2[Mail Type])), fn = (t) => [s1 = List.Sum(t[订舱重量]), s2 = 源[账单重量]{0},w = if s2 <> s1 then [r = List.Last(List.PositionOf(t[订舱重量],List.Min(t[订舱重量]),#infin

[求助] Power Query根据其他列数值替换ABY12N32题目：如果A列第n行=12，替换该行B列的值为100。方法1：= Table.ReplaceValue(更改的类型, each [B], each if [A]="Y" then 100 else [B], Replacer.ReplaceValue,{"B"})方法2：= Table.ReplaceValue(更改的类型, each [A]="Y", 100, (X,Y,Z)=>i.