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- lbendlin
Ashish_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.
Thank you very much! I have been cracking my brain over this. I will go over your solution and learn from it before using it.
- Ashish_Mathur
You are welcome.
