Forum Discussion

rlsantos's avatar
rlsantos
Frequent Visitor
4 years ago
Solved

MEASURE YY% WORKING SLOW

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];-...
  • smpa01's avatar
    smpa01
    4 years ago

    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)
smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
4 years ago

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's avatar
rlsantos
Frequent Visitor
4 years ago

Thanks Bro!!
It worked 

  • smpa01's avatar
    smpa01
    Icon for Community Champion rankCommunity Champion
    4 years ago

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