Forum Discussion
LukeReds
Helper II
Helper IIcalculate compound interest
Hi to everyone,
i have a initial table like in the pic below, there are the interests year by year. I have a 1 cell table also with the initial amount
How can i get the result as in the second pic (Final table, field "amount"), using power query (no dax no excel formula)? Thank you!!
2 Replies
LukeRedsthank you, i just changed this line
Result = Table.AddColumn(Index, "Result", each(100+First_variation) * List.Product(List.FirstN(Daily_variation,[Index]))
with this one
Result = Table.AddColumn(Index, "Result", each (100*(1+First_variation)) * List.Product(List.FirstN(Daily_variation,[Index])))
