Calculate difference between categories

[Anonymous]

I'm looking for a method to show the difference in velocity between project ending dates.

Represented here is the average velocity achieved between project end dates.

So, I'd want to create a graph that would show:

Velocity	1	1.8	1	1.5	0.9	1.5	1.2	0.5	1	1.1	0.8	0.6	0
	2/18/2021	3/4/2021	3/18/2021	4/1/2021	4/15/2021	4/29/2021	5/13/2021	5/27/2021	6/10/2021	6/24/2021	7/15/2021	7/29/2021	8/12/2021
Difference	1	0.8	-0.8	0.5	-0.6	0.6	-0.3	-0.7	0.5	0.1	-0.3	-0.2	-0.6

+0.8 (delta between 1 and 1.8)

-0.8 (delta between 1.8 and 1.0)

+0.5 (delta between 1.0 and 1.5)

-0.4 (delta between 1.5 and 0.9)

.... and so on

I thought a quick measure to show variance in velocity would solve this, but it does not.

Most all solutions around DAX and VAR I've found do not work in this instance, because 'velocity' is a calculated measure.

Any guidance would be much appreciated. Thank you!

[amitchandak · Accepted solution]

@Anonymous , Try a measure like

measure =
Var _last = maxx(filter(allselected(Table), Table[Date] < max(Table[Date])),Table[Date])
return
sum(Table[Velocity]) - calculate(sum(Table[Velocity]) ,filter(allselected(Table),Table[Date] =_max))