Need A dynamic Year Title Dax Calc

[Igotzepowerbi]

Hello,

I have three year measures and my client wants the titles to be dynamic. So instead of saying Last Year Sum it would say 2023 - 2 years ago would say 2022. I don't want to have to change the titles every year. Does anyone know of a way to accomplish this?
Example of current dax calc.

2 years ago =

IF (

    SELECTEDVALUE ( 'Dollars / Units'[selected Dollars/Units Name] ) = "Dollars",

    CALCULATE (

        [sum of dollars],

        FILTER (

            'POS Aggregate',

            YEAR ( 'POS Aggregate'[Week End Date] )

                = YEAR ( TODAY () ) - 2

        )

    ),

    IF (

        SELECTEDVALUE ( 'Dollars / Units'[selected Dollars/Units Name] ) = "Units",

        CALCULATE (

            [sum of units],

            FILTER (

                'POS Aggregate',

                YEAR ( 'POS Aggregate'[Week End Date] )

                    = YEAR ( TODAY () ) - 2

            )

        )

    )

)

[Anonymous]

Hi @Greg_Deckler ,thanks for the quick reply.

Hi @Igotzepowerbi ,

Regarding your question, is your requirement to dynamically modify the name of the measure based on the year selected by the slicer? I don't think this can be done, we can only dynamically select the output value.

[Greg_Deckler]

@Igotzepowerbi The Most Amazing, Mind Blowing Dynamic Slicer Titl... - Microsoft Fabric Community