Forum Discussion
Acummulated yield adding yield to initial quantity
Dears mates,
I would like to calculate the accumulated yield from an initial quantity of 100.000 after of this first row the quantity will be the previous ren_acum plus initial.
How Could I do this matrix?
| ren | initial | ren_acum | |
| 6,5% | 100000 | 6495 | |
| 0,3% | 0 | 6515 | |
| 2,6% | 0 | 6683 | |
| 2,4% | 0 | 6844 | |
| 4,0% | 0 | 7115 |
Many thanks in advance
carenel see attached, tweak it as you see fit. I broken down the solution into 3 measures
- initial rent
- accumulated rent %
- accumulate rent
✨ Follow us on LinkedIn
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
1 Reply
carenel see attached, tweak it as you see fit. I broken down the solution into 3 measures
- initial rent
- accumulated rent %
- accumulate rent
✨ Follow us on LinkedIn
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡