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
Community Champion
4 years ago

rlsantos  can you try SAMEPERIODLASTYEAR syntax?

  • rlsantos's avatar
    rlsantos
    Frequent Visitor
    4 years ago

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

    • smpa01's avatar
      smpa01
      Community 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