Datediff from nonconsecutive rows, group by category
Hello - I'm stumped finding the date difference between nonconsecutive rows, grouped by category. ProjectID is the "category", I need to caculate the time in between the previous record and a newly created record is that has the same ProjectID.
Regarding the suggestion to add the previous value: I'm not sure how to grab the previous value from the same ProjectID. And the ProjectID is not static, there will be new ones regularly. Though I think the PowerQuery is the way to go:
I am cautoius about using the EARLIER function. The article suggests serious lag time due to number of operations.