cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
PeterStuhr Frequent Visitor
Frequent Visitor

Calculate a winrate for LYTD

Hi all

 

I am working with Opportunities won / lost in Power BI. 

All closed opportunities has a status (won / lost) and a close date.

 

I have done my YTD calculation which works:

 

WinRate YTD = CALCULATE ( DIVIDE ( CALCULATE ( COUNT ( CRMOpportunities[OpportunityStatus] ); CRMOpportunities[OpportunityStatus] = "Won" ); CALCULATE ( COUNT ( CRMOpportunities[OpportunityStatus] ); CRMOpportunities[OpportunityStatus] IN { "Won"; "Lost" } ) ); YEAR(CRMOpportunities[OpportunityCloseDate])=YEAR(TODAY()))
 
Now I would need help with a calculation for Last Year To Date for comparison. Thanks a lot!
1 REPLY 1
Super User
Super User

Re: Calculate a winrate for LYTD

See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!