How to compare the count on a given day to the count in the previous year same day

[Cevola]

I need to compare the count on a given day to the count in the previous year same day. Compare the data of 5 Mar 2023 to 5 March 2023. How can i achieve this in DAX.

[tamerj1]

HI @Cevola 

Count Previous Year = CALCULATE ( [Count], SAMEPERIODLASTYEAR ( 'Date'[Date] ) )

If no Date table then

Count Previous Year =
VAR CurrentDate = MAX ( 'Table'[Date] )
RETURN
    CALCULATE ( [Count], 'Table'[Date], = DATE ( YEAR ( CurrentDate ) - 1, MONTH ( CurrentDate  ), DAY ( CurrentDate  ) ) )