Comparing YTD to Previous Year

Hi RobKay12 ,

Based on your description, I created these data.

Create MEASURE.

MEASURE = 
VAR _max_date =
    CALCULATE ( MAX ( '2024'[date] ), ALL ( '2024' ) )
VAR _min_date =
    CALCULATE ( MIN ( '2024'[date] ), ALL ( '2024' ) )
VAR _last_year_start =
    DATE ( YEAR ( _min_date ) - 1, MONTH ( _min_date ), DAY ( _min_date ) )
VAR _last_year_end =
    DATE ( YEAR ( _max_date ) - 1, MONTH ( _max_date ), DAY ( _max_date ) )
VAR _sum =
    CALCULATE (
        SUM ( '2023'[event] ),
        FILTER (
            ALL ( '2023' ),
            '2023'[date] >= _last_year_start
                && '2023'[date] <= _last_year_end
                && '2023'[site] = MAX ( '2024'[site] )
        )
    )
RETURN
    _sum

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.