Dynamic Same Time Last Year

Hi Anonymous ,

For your problem, here is the solution I have given which should optimize your DAX query taking too long.

Measure = VAR current1 =MAX('financials'[Date])
VAR late =DATE(YEAR(current1)-1 ,MONTH(current1),DAY(current1)
)
RETURN  CALCULATE(SUM(financials[ Sales]),financials[Date]<=late, YEAR('financials'[Date])=YEAR(late))

I kept your first two self-defined parameters and then calculated your latter part directly using caculate,

in my example data, the speed is getting faster, I hope this helps.

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.