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. 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))
            )
        )

 

Need Help

2 Replies

  • 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 )