等额插值

2019-10-17 10:33:19 ⋅ 2010 ⋅ 1 ⋅ 0

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的恩怨纠葛

自由转载-非商用-非衍生-保持署名（创意共享3.0许可证）