DAX - YTD (Except the current quarter)

[agd50]

Would anyone know how to turn this into a YTD formula (excluding the current quarter)?
Thanks

[Ahmedx · Accepted solution]

pls try this

=
    VAR _today = TODAY()
    VAR StartDate = DATE(YEAR (_today),1,1)
    VAR EndDate = DATE ( YEAR ( _today ), FLOOR ( MONTH (_today ) -1 , 3 ) + 1 , 1 )-1
    VAR Results = CALCULATE([Count of], DATESBETWEEN('Calendar'[Date],StartDate,EndDate))
    RETURN
    Results

[agd50]

That indeed has worked, well done!