cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## 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];-1;YEAR))-1;0)

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

1 ACCEPTED SOLUTION
Super User

@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)
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs
5 REPLIES 5
Super User

@rlsantos  can you try SAMEPERIODLASTYEAR syntax?

Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs
Frequent Visitor

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

Super User

@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)
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs
Frequent Visitor

Thanks Bro!!
It worked

Super User

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

Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.