Forum Discussion
Find Max ROI By Dynamic Group
Hi everyone, I have a table that looks something like this: Year Channel Investment Revenue 2017 Social 1000 3000 2017 Search 200 500 2017 TV 4000 15000 2018 Social 12...
trine_norris what is not working the solution posted above?
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos 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.⚡
Hi,
The max ROI should always be found for all years, not just the selected ones.
And it still seems as though it calculates the ROI for each channel, and not aggregated.