Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Daily Return % | Growth | |
10000 | ||
0.607 | 10060.769 | =B2 * ( 1 + A3/100) |
0.502 | 10111.373 | =B3 * ( 1 + A4/100) |
0.399 | 10151.813 | =B4 * ( 1 + A5/100) |
-0.702 | 10080.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
Very likely, if you could share you Excel file via OneDrive or Box or something that would greatly assist.
Hi Gerg,
I added coumn header and row numbers to the image to better understand the formula. I hope this helps.
User | Count |
---|---|
14 | |
9 | |
8 | |
7 | |
5 |
User | Count |
---|---|
24 | |
16 | |
15 | |
10 | |
7 |