cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Calculating the diference from a value to a previous row in function of an id and date

Dear Team,

 

I would like to be able to calculate the following difference column, it seems that it's a hard nut to crack.

 

IDDATEREADINGDifference
A1/10/20192313
A30/09/2019105
A26/09/201950
B5/08/20195024
B3/08/2019266
B2/06/20192020
C1/09/20196727
C6/08/20194017
C1/01/20192323

Everything is very welcome,

 

Greatly appreciated

3 REPLIES 3
Highlighted
Helper I
Helper I

Re: Calculating the diference from a value to a previous row in function of an id and date

Dear @Wizzy_1989 

You can create a column which calculates the previous READING using date/period and calculate the difference between those two columns.

 

Regards, 

Munna 

Highlighted
Helper I
Helper I

Re: Calculating the diference from a value to a previous row in function of an id and date

Highlighted
Community Support
Community Support

Re: Calculating the diference from a value to a previous row in function of an id and date

Hi @Wizzy_1989 

 

Sorry, I don't understand the calculation logic, could you please specify more? Does the difference column is the expected results? how does it count? 

If you'd like to count the difference in adjacent rows, the output seems incorrect.

 23-10=13

10-5=5

5-50=0????

50-26=24

26-20=6

20-67=20???

67-40=27

40-23=17

23-0=23

 

 

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors
Top Kudoed Authors