Forum Discussion
Solved
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 Re...
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:
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 👍
