wdx223

第 100 位会员
注册于 2018-09-05 16:05:53
活跃于 2020-01-21 15:57:23
  1. 个人中心
  2. Ta 发表的回复（31）
  • 如何得到明细列之和于合计列的新列 at 2018-10-13 08:38:55

    let
    HJ = Excel.CurrentWorkbook(){[Name="表2"]}[Content],
    MX = Excel.CurrentWorkbook(){[Name="表1"]}[Content],
    Custom1 = Table.Group(MX,"ld",{"n",each List.Accumulate(List.Sort([明细],1),{},(x,y)=>x&{List.Min({Table.SelectRows(HJ,(h)=>h[ld]=[ld]{0})[合计]{0}-List.Sum(x),y})})}),

    "Expanded {0}" = Table.ExpandListColumn(Custom1, "n")

    in

    "Expanded {0}"