Distribute pre-payments

Hi Anonymous , 

I think you could use M code to achieve this goal.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("RczLDQAhCATQXjib8FW3im3A0H8bC2zUE8y8ZNaCl4gYGghOFBKKd0SVB7z9LpE6Ptu5l+txzYS2fWq5Hbfa57ufI+D+AQ==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [InvoiceNo = _t, #"Invoice Date" = _t, Amount = _t, Terms = _t]),
    #"Changed Type1" = Table.TransformColumnTypes(Source,{{"InvoiceNo", type text}, {"Invoice Date", type date}, {"Amount", Int64.Type}, {"Terms", Int64.Type}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type1", "Custom", each {Number.From([Invoice Date])..Number.From(Date.AddDays([Invoice Date],[Terms]-1))}),
    #"Expanded Custom" = Table.ExpandListColumn(#"Added Custom", "Custom"),
    #"Changed Type" = Table.TransformColumnTypes(#"Expanded Custom",{{"Custom", type date}}),
    #"Added Custom1" = Table.AddColumn(#"Changed Type", "Custom.1", each [Amount]/[Terms]),
    #"Removed Columns" = Table.RemoveColumns(#"Added Custom1",{"Invoice Date", "Amount"}),
    #"Renamed Columns" = Table.RenameColumns(#"Removed Columns",{{"Custom", "date"}, {"Custom.1", "amount"}})
in
    #"Renamed Columns"

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.