DateDiff Between Rows

[Gillard_2]

Hi all,

I have a data set that is pulling from a sharepoint list. I have succesfuul manage to not only pull in the records but all the version history too, as as individual rows.

What i am trying to achieve is a duration column which shows the length of time between each version for all records.

I have a unique ID column which distinguishes between the sharepoint items, and i have the version column.

So i need something like:

DateDiff(ModifiedDate,Previous versions Modified Date for this specific record) The red bit is the bit i am struggling with.

They wont always be in the nice organised order you see below and there will be a big mix of Unique Record IDs. But they will always increase in increments of 1.

Hope that makes sense.

Any help would be great thanks

[Anonymous · Accepted solution]

Hi @Gillard_2 ,

You could use EARLIER() function.

diff = 
var _previous = calculate(max('table'[modified date]),filter('table','table'[recordid] = earlier('table'[recordid])&&'table'[version] = earlier('table'[version])-1))
return
datediff('table'[modified date],_previous,day)

Best regards,

Jay