Dynamic columns/measures in matrix

Hi cheryl0316 

Ensure that you have a separate date dimensions table. Creat the following measures

Current Year = 
VAR _Year = CALCULATE ( MAX ( Dates[Year] ), ALLSELECTED ( Dates ) )
RETURN
    CALCULATE (
        SUM ( 'Table'[Revenue] ),
        KEEPFILTERS ( Dates[Year] = _Year )
    )

Previous Year = 
VAR _Year = CALCULATE ( MIN ( Dates[Year] ), ALLSELECTED ( Dates ) )
RETURN
    CALCULATE (
        SUM ( 'Table'[Revenue] ),
        KEEPFILTERS ( Dates[Year] = _Year )
    )

Difference = 
[Current Year] -  [Previous Year]

Create these calculation items

Last Week = 
CALCULATE(
    SELECTEDMEASURE(),
    FILTER(
        ALL('Table'[Week No]),
        'Table'[Week No] = 52
    )
)
--NOTE: no 53  in your sample data for 2023 and 2024

Last Month = 
CALCULATE(
    SELECTEDMEASURE(),
    FILTER(
        ALL ( 'Dates' ),
        Dates[Month Number] = 12
    )
)

Last Quarter = 
CALCULATE(
    SELECTEDMEASURE(),
    FILTER(
        ALL(Dates),
        Dates[Quarter] = 4
    )
)