Using variables to simplify measures

[KaterineCAA]

I have a serie of measure that always have the same format. I would like to use variables so that when I copy a measure, I always have to only have to change the measure that is refered in it once. But, when I try, it returns 0. What am I doing wrong?

Noto POND (-1 an) = 

var mesure = [Noto POND TOTAL]
return

CALCULATE(
    mesure; 
        SAMEPERIODLASTYEAR(
            DATESBETWEEN(
                'Table Dates'[Date];
                DATE(YEAR(LASTNONBLANK ( 'Table Dates'[Date];mesure));01;01);
                DATE(YEAR(LASTNONBLANK ( 'Table Dates'[Date];mesure));12;31))
            )
        )

[Nathaniel_C]

Hi @KaterineCAA , try it this way.


Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

Noto POND (-1 an) =
VAR mesure = [Noto POND TOTAL]
VAR _calc =
    CALCULATE (
        mesure;
        SAMEPERIODLASTYEAR (
            DATESBETWEEN (
                'Table Dates'[Date];
                DATE ( YEAR ( LASTNONBLANK ( 'Table Dates'[Date]; mesure ) ); 01; 01 );
                DATE ( YEAR ( LASTNONBLANK ( 'Table Dates'[Date]; mesure ) ); 12; 31 )
            )
        )
    )
RETURN
    _calc

[KaterineCAA]

Thanks for your reply @Nathaniel_C 

However, it doesn't work. I've tried with a simpler measure.

MESURE TEST (année en cours) = 

VAR mesure = [Noto POND TOTAL]

VAR _calc = DATE ( YEAR ( LASTNONBLANK ( 'Table Dates'[Date] ; mesure ) ) ; 01 ; 01 )

RETURN

_calc

 This mesure returns 2020-01-01 and the next one, returns 2019-01-01 (which is what it should be)...

MESURE TEST (année en cours) = 

VAR _calc = DATE ( YEAR ( LASTNONBLANK ( 'Table Dates'[Date] ; [Noto POND TOTAL] ) ) ; 01 ; 01 )