Forum Discussion

KaterineCAA's avatar
KaterineCAA
Frequent Visitor
6 years ago

Using variables to simplify measures

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. B...
Need Help
Nathaniel_C's avatar
Nathaniel_C
Community Champion
6 years ago


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's avatar
KaterineCAA
Frequent Visitor
6 years ago

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 )