Forum Discussion
Dimenshing Return
Community ChampionAymansg Sounds interesting. Should be possible via a DAX while loop I'm thinking. But, would need sample data and expected output to be specific.
Thanks alot for your contribution, I read through you article about for and while loops and will definitely give it a try but can you please advise on what do you mean by expected output?
The dataset is broken by day and it is a real time data that is fetched from a data source.
The dataset includes amount spent and cost per result so there is a maximum amount of spend that we reach before the cost keeps on increasing after.
Leaving the article link here for reference in case anyone wants to check it: https://community.powerbi.com/t5/Community-Blog/For-and-While-Loops-in-DAX/ba-p/636314
- Greg_Deckler
Aymansg Well, really what I need to get started on this is for you to paste in some sample data. Or point me to some sample data.
Here is a dummy sample data for your reference:
Platform Date Spend Cost
Facebook 1 2,366 3.2
Facebook 2 1,577 1.7
Facebook 3 3,627 2.7
Facebook 4 2,636 2.3
Facebook 5 3,326 3.2
Facebook 6 1,782 2.3
Facebook 7 6,213 2,4
Facebook 8 3,163 3.2
Facebook 9 4,118 3.4
I have historical data for two years and can breakdown by day/week/month and for different platforms.
- Greg_Deckler
Aymansg Here is what I did, I ripped off a couple examples from here: Law of Diminishing Returns - Definition, Examples, Diagrams (wallstreetmojo.com)
I recreated these in Power BI. PBIX file is attached below signature. I implemented the diminishing returns as a calculated column. Turned out that this was MTBF and not a while loop. But, could implmenent a while loop to automatically identify where the diminishing returns kicks in.