Dimenshing Return

Question

I am a new user to DAX and wanted to know if it is doable to create a dimenshing return model in power bi. I have been creating it using Excel sheets but wanted to include it in the dashboard.

I have researched and found models for Linear Regression and Correlation but not for Dimenshing Return.

Can someone please advice?

greg_deckler · Answer

Aymansg&nbsp;Sounds interesting. Should be possible via a DAX while loop I'm thinking. But, would need sample data and expected output to be specific.

aymansg · Answer

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 · Answer

Aymansg&nbsp;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.

greg_deckler · Answer

Aymansg&nbsp;Here is what I did, I ripped off a couple examples from here:&nbsp;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.
&nbsp;

aymansg · Answer

Here is a dummy sample data for your reference:&nbsp;Platform&nbsp; &nbsp;&nbsp;Date&nbsp; Spend&nbsp; &nbsp;CostFacebook&nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; 2,366&nbsp; &nbsp; &nbsp; 3.2Facebook&nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; 1,577&nbsp; &nbsp; &nbsp; 1.7Facebook&nbsp; &nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; 3,627&nbsp; &nbsp; &nbsp; 2.7Facebook&nbsp; &nbsp; &nbsp;4&nbsp; &nbsp; &nbsp; 2,636&nbsp; &nbsp; &nbsp; 2.3Facebook&nbsp; &nbsp; &nbsp;5&nbsp; &nbsp; &nbsp; 3,326&nbsp; &nbsp; &nbsp; 3.2Facebook&nbsp; &nbsp; &nbsp;6&nbsp; &nbsp; &nbsp; 1,782&nbsp; &nbsp; &nbsp; 2.3Facebook&nbsp; &nbsp; &nbsp;7&nbsp; &nbsp; &nbsp; 6,213&nbsp; &nbsp; &nbsp; 2,4Facebook&nbsp; &nbsp; &nbsp;8&nbsp; &nbsp; &nbsp; 3,163&nbsp; &nbsp; &nbsp; 3.2Facebook&nbsp; &nbsp; &nbsp;9&nbsp; &nbsp; &nbsp; 4,118&nbsp; &nbsp; &nbsp; 3.4&nbsp;&nbsp;I have historical data for two years and can breakdown by day/week/month and for different platforms.

Forum Discussion

Dimenshing Return

5 Replies

Related content

Measure returning incorrect value

Date Different return wrong value

MAXX Returning duplicate values

List.Zip Returning an error

FORMAT() returns Month Number