Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
Need Help
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    5 years ago

    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))

amitchandak's avatar
amitchandak
Super User
5 years ago

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))