Calculation with multible variables in time

Hi, Anonymous 

Based on the data you provide, you can try the following methods.

Current value = SUM(Data[Value])

Previous value = 
Var PrevDate=MAXX(FILTER(ALL('Data'[Date],Data[Year]),'Data'[Date]<SELECTEDVALUE('Data'[Date])&&[Year]=SELECTEDVALUE(Data[Year])),'Data'[Date])
Var Prevalue=CALCULATE([Current value],FILTER(ALL(Data),[Date]=PrevDate))
Return
Prevalue

Outcome = IF([Previous value]<>BLANK(), [Current value]-[Previous value])

The result of the calculation is different from the result you expect. Consider if there is a problem with your desired result calculation?

Let me give you an example.

But in your results.

Please check if there is a problem with your result calculation in Excel, thank you.

Best Regards,

Community Support Team _Charlotte

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