Greg_Deckler's avatar
Greg_Deckler
Community Champion
7 years ago

Compound Interest

Simple Compound Interest Quick Measure: 

 

 

Future Value = 
VAR __principal = [Principal Value]
VAR __r = [Effective Rate]
VAR __n = [n Value]
VAR __t = [t Value]
RETURN
__principal*POWER((1+__r/__n),(__n*__t))

 

 

1 Reply

  • Man this makes my life so much easier! I'm trying to automate some of my price estimation using Power Bi and that just made my day!