Predict and distribute a payment plan

Hi JGG ，

Try the following code in Power Query Editor:

let
    Source = Table.FromValue(#"Table (2)"),
    #"Added Custom" = Table.AddColumn(Source, "PayDay", each List.Dates([due dates], 40, Duration.From(1))),
    #"Expanded Custom" = Table.ExpandListColumn(#"Added Custom", "PayDay"),
    #"Added Custom1" = Table.AddColumn(#"Expanded Custom", "Payment", each if [PayDay]=[due dates] then [invoice amounts]*0.75 
                                                                                else if Duration.TotalDays([PayDay]-[due dates])<=5 then [invoice amounts]*0.02 
                                                                                    else if Duration.TotalDays([PayDay]-[due dates])<=10 then [invoice amounts]*0.01 
                                                                                        else [invoice amounts]*0.002),
    #"Removed Columns" = Table.RemoveColumns(#"Added Custom1",{"due dates", "invoice amounts"}),
    #"Changed Type" = Table.TransformColumnTypes(#"Removed Columns",{{"Payment", type number}})
in
    #"Changed Type"

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

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