Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |