Calculate a winrate for LYTD

[PeterStuhr]

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!

[Greg_Deckler]

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...