Forum Discussion
return rate
Hi,
sorry for that noob-question 🙂
I got an table includiing "timestamp" "revenue"
Negativ Revenues = returns
I like to create a chart including the historical Return-rate
Calculating the Return-rate per day like:
Return-rate=Sum(negativ revenue)/Sum(positiv revenue)
Could you please help me how to do that?
Thanks a lot.
Sample data always helps. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Return Rate = ABS( DIVIDE( SUMX(FILTER('Table',[Revenue]<0),[Revenue]), SUMX(FILTER('Table',[Revenue]>0),[Revenue]), 0 ) )But, you will probably want something like:
3 Replies
Sample data always helps. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Return Rate = ABS( DIVIDE( SUMX(FILTER('Table',[Revenue]<0),[Revenue]), SUMX(FILTER('Table',[Revenue]>0),[Revenue]), 0 ) )But, you will probably want something like:
Thanks a lot Greg_Deckler that works. My next Question will be much more professional 👍
