Forum Discussion

M-M-P's avatar
M-M-P
Helper III
6 years ago
Solved

Subtract the current value from the previous value?

Hello everyone   I've been struggling with a calculated column. I have a table that looks like this:   I'm trying to subtract the current value from the previous value so I get a new colum...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    Hi,

    Does this work?

    Data[Value]-LOOKUPVALUE(Data[Value],Data[Timestamp],CALCULATE(MIN(Data[Timestamp]),FILTER(Data,Data[Timestamp]>EARLIER(Data[Timestamp])&&Data[UnitID]=EARLIER(Data[UnitID]))),Data[UnitID],Data[UnitID])
Ashish_Mathur's avatar
Ashish_Mathur
Super User
6 years ago

You are welcome.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Ashish_Mathur 

    Hi

    I tried to use this calculation but got an error and that it expect the token Literal. Do you know why? The collum UnitID is changed with Device in my case, otherwise it's the same with value and timestamp

     

     

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      5 years ago

      Hi,

      My formula has to be written as a calculated column formula (not as a M language formula).