Forum Discussion
Win Rate
Hi there!
I have a table with the 'Sales Information', includes the follwing columns:
[Deal Status] -> Active, Signed, Abondend, Booked, Lost.
[Deal value] -> Numeric Data.
I want to add a new column [Win Rate] applying the logic of: Win Rate = won deals value/ won deals value+ lost deals value
Which function should I use for this and how should I write it?
Thanks a lot in advance
6 Replies
Hadill , where are these values
won deals value/ won deals value+ lost deals
Can you share sample data and sample output in table format?Hi amitchandak , thanks for replying.
By Won Deals value i mean the sum of the deal values that corresponds Booked status.
And the same for Lost Deals value, corresponds Lost status.
So it should be : win rate= sum of [deal value] for the booked [deal status]/sum of [deal value] for the booked [deal status]+sum of [deal value] for the Lost [deal status].
Example of the columns:
Deal value Deal status 500 Booked 1000 Abounded 400 Booked 1500 Lost 2000 Lost 1500 Abounded 4000 signed I hope it is more clear now
Hadill , Try a measure like
Divide( Calculate(Sum(Table[Deal Amount] ), Filter(Table, Table[Status] ="Booked")) ,Calculate(Sum(Table[Deal Amount] ), Filter(Table, Table[Status] in{"Booked","Lost"} )))
Hi, Hadill
Please consider sharing sample data with date column and date by quarter column and desired output.It makes it easier to give you a solution.
- Sample (dummy dataset) data as text, use the table tool in the editing bar
- Expected output from sample data
- Explanation in words of how to get from 1. to 2.
Best Regards,
Community Support Team _ Zeon ZhengIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
