Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Hi,
So i'm a novice when it comes to Power BI. I need help with ROI. How do I calculate ROI from a set of data? What type of formula should I use? I need the rate to show in both sum and percent form. Appreciate your response. I am willing to share sample data if needed.
Solved! Go to Solution.
@Ash_09 ,Refer these
https://www.youtube.com/watch?v=HAPzlwHndR4
https://www.youtube.com/watch?v=zBu-YPC4h1c
https://www.youtube.com/watch?v=C5GbKa2eHxU
https://community.powerbi.com/t5/Desktop/cumulative-portfolio-returns/m-p/275884#M123036
https://community.powerbi.com/t5/Desktop/Calculating-ROI-equalizing-point-in-time/m-p/475033
Thank you both of you I've got it now 👍
@Ash_09 the below post will guide you in the right direction.
https://community.powerbi.com/t5/Desktop/cumulative-portfolio-returns/m-p/275884#M123036
@Ash_09 ,Refer these
https://www.youtube.com/watch?v=HAPzlwHndR4
https://www.youtube.com/watch?v=zBu-YPC4h1c
https://www.youtube.com/watch?v=C5GbKa2eHxU
https://community.powerbi.com/t5/Desktop/cumulative-portfolio-returns/m-p/275884#M123036
https://community.powerbi.com/t5/Desktop/Calculating-ROI-equalizing-point-in-time/m-p/475033
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Check out the February 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 53 | |
| 47 | |
| 30 | |
| 15 | |
| 14 |
| User | Count |
|---|---|
| 88 | |
| 73 | |
| 38 | |
| 26 | |
| 25 |