等额插值

file

let
    源 = Excel.CurrentWorkbook(){[Name="表1"]}[Content],
    组 = Table.Group(源,"num",{"a",Table.RowCount},0,(x,y)=>Byte.From(y is number)),
    差 = List.Transform(List.Zip({组[num],List.Skip(组[num])}),each _{1}-_{0}),
    自定义2 = List.Combine(List.Transform(List.Zip(Table.ToColumns(组)&{差}),each List.Numbers(_{0},_{1},_{2}/_{1})))
in
    自定义2

道高一尺 魔高一丈
https://pbihub.cn/users/44
M与DAX的恩怨纠葛