- let
Source = Excel.CurrentWorkbook(){[Name="表1"]}[Content],
Custom1 = Table.AddColumn(Source,"PN求和",
each [
a=Record.ToList(_),
b=Table.ColumnNames(Source),
c=List.Sum(List.Transform({0..List.Count(b)-1}, (x)=>if Text.Contains(b{x},"PN") then a{x} else 0))
][c]
)
in
Custom1
复制代码 |