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])
M-M-P's avatar
M-M-P
Helper III
6 years ago

Hi AlB Ashish_Mathur 

Thank you very much for your response.

Your solutions works. But unfortunately only if I filter my data hard in the Querie editor.

Unfortunately, I have simplified my example table too much.

 

I do not have unique Timestamps because there are several units in the same table that have values logged at the same time. See a more correct example below:

Next time I will remember to include all the important parameters :)

Ashish_Mathur's avatar
Ashish_Mathur
Super User
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])
  • M-M-P's avatar
    M-M-P
    Helper III
    6 years ago

    Ashish_Mathur 
    Thanks a lot it works :)

    • 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