Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
Anonymous
Not applicable

How to calculate growth of initial investment over time

Daily Return  %Growth  
 10000 
0.60710060.769=B2 * ( 1 + A3/100)
0.50210111.373=B3 * ( 1 + A4/100)
0.39910151.813=B4 * ( 1 + A5/100)
-0.70210080.470=B5 * ( 1 + A6/100)

 

Hi ,

I have a column in my dataset with daily return percentage, now I need to create a meausre or caluclated column that starts with $10000 initial investment and calculate the growth based on daily return.

I have attched Excel formulas to show the calculation method. 

Ideally the frmula should respond to fund selection by the user ( slicer ).

Can be done in Power BI?

 

 

Thank you

3 REPLIES 3
Greg_Deckler
Community Champion
Community Champion

Very likely, if you could share you Excel file via OneDrive or Box or something that would greatly assist. 



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

POwer BI Q.gif

 

Hi Gerg,

I added coumn header and row numbers to the image to better understand the formula. I hope this helps.

Anonymous
Not applicable

There's no file attached.

For such calculations, you have to use:
https://dax.guide/productx/

Best
D

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.