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:
See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
Proud to be a Datanaut!