Forum Discussion
Calculate difference between categories
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!
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))
1 Reply
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))