https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/Compound-Interest/m-p/627014#M310 <P>Simple Compound Interest Quick Measure:&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <PRE>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))</PRE> <P>&nbsp;</P> <P>&nbsp;</P> <P><SPAN class="reportid hidden">eyJrIjoiZjZmMjE3NGItYmIzZi00YjYwLWIyY2MtNjZmNzM5YzQ4ZjBlIiwidCI6IjRhMDQyNzQzLTM3M2EtNDNkMi04MjdiLTAwM2Y0YzdiYTFlNSIsImMiOjN9</SPAN></P> Thu, 21 Feb 2019 21:15:17 GMT Greg_Deckler 2019-02-21T21:15:17Z https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/Compound-Interest/m-p/627014#M310 <P>Simple Compound Interest Quick Measure:&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <PRE>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))</PRE> <P>&nbsp;</P> <P>&nbsp;</P> <P><SPAN class="reportid hidden">eyJrIjoiZjZmMjE3NGItYmIzZi00YjYwLWIyY2MtNjZmNzM5YzQ4ZjBlIiwidCI6IjRhMDQyNzQzLTM3M2EtNDNkMi04MjdiLTAwM2Y0YzdiYTFlNSIsImMiOjN9</SPAN></P> Thu, 21 Feb 2019 21:15:17 GMT https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/Compound-Interest/m-p/627014#M310 Greg_Deckler 2019-02-21T21:15:17Z https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/Compound-Interest/m-p/2966348#M935 <P>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!</P> Tue, 13 Dec 2022 20:40:17 GMT https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/Compound-Interest/m-p/2966348#M935 Ramzoid 2022-12-13T20:40:17Z