cancel
Showing results for
Did you mean:
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
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``````

Frequent Visitor

## Re: Using variables to simplify measures

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

Announcements

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

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

#### Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)