Forum Discussion
Compounding Interest Table
Hello, I would like to replicate this table in Excel below, but using Power BI. and there is interest rate in cell C16. In Excel, for Cell D2, the value would be: D2 =C2*(1+$...
Ashish_Mathur
Super User
Super User
lbendlinSuper User
Super UserAshish_Mathur great approach. Here is a slightly simpler version, but the idea is the same.
FV2 =
var y = max(Data[Date])
var a = SUMMARIZE(ALLSELECTED(Data),Data[Date],"comp",sum(Data[Yearly savings]),"pow",year(y)-year([Date])+1)
return sumx(filter(a,[pow]>0),[comp]*1.1^[pow])
- Ashish_Mathur
Thank you lbendlin for sharing your knowledge. It indeed is a much shorter formula than mine.