topic Re: MEASURE YY% WORKING SLOW in DAX Commands and Tips

MEASURE YY% WORKING SLOW

rlsantos — Fri, 08 Oct 2021 20:24:14 GMT

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 — Fri, 08 Oct 2021 20:32:55 GMT

rlsantos can you try SAMEPERIODLASTYEAR syntax?

rlsantos — Sat, 09 Oct 2021 20:45:02 GMT

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

smpa01 — Sun, 10 Oct 2021 05:30:55 GMT

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 — Sun, 10 Oct 2021 20:37:38 GMT

Thanks Bro!!
It worked

smpa01 — Sun, 10 Oct 2021 22:28:40 GMT

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