Forum Discussion

M-M-P's avatar
M-M-P
Icon for Helper III rankHelper 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])
eleanoracook's avatar
eleanoracook
New Member
3 years ago

Hello,

 

I'm looking for help with a similar query where I want to subtract from a value three hours previous to the current row or 37 rows earlier rather than just the previous value. I'm very new to PowerBI so any help would be appreciated. Also for others reading the previous solution with as little knowledge as me, you need to change 'data' to your table name for it to work.

Thanks,

 

Eleanor

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
3 years ago

Hi,

Share some data to work with in a format (that can be pasted in an MS Excel file) and show the expected result.