MEASURE YY% WORKING SLOW

[rlsantos]

Hi everyone!

Who can help me with this?

I have a simple mesure tha calculate % in same period from last year.

REAL SALES YY%:=IFERROR([REAL SELLIN]/CALCULATE([REAL SELLIN];DATEADD(d_DATES[DATES];-1;YEAR))-1;0)

This measure is Working very very Slow, can enyone tell me whats wrong?

[smpa01]

@rlsantos  can you try SAMEPERIODLASTYEAR syntax?

[rlsantos]

I've already tried, but it doesn't matter, it's slow

[smpa01 · Accepted solution]

@rlsantos  can you try using the variables and see if it improves the performance

Measure:=
VAR _0 = [REAL SELLIN]
VAR _1 = CALCULATE(_0, SAMEPERIODLASTYEAR(d_DATES[DATES]))
VAR _2 = DIVIDE(_0,_1)
RETURN IFERROR(_2,0)

[rlsantos]

Thanks Bro!!
It worked 

[smpa01]

@rlsantos  glad to be of help. Can you please accept the answer.