cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KaterineCAA Frequent Visitor
Frequent Visitor

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

 

2 REPLIES 2
Nathaniel_C Super Contributor
Super Contributor

Re: Using variables to simplify measures


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 Frequent Visitor
Frequent Visitor

Re: Using variables to simplify measures

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 )

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)