Look for a specific key in subsequent rows - calculated columns

[Jess123]

Hi,

I am having a hard time doing a calculated column that needs to, for each row, look for the next row that contains the same "ObjectKey" in the earliest timespan, and then do the current "Value of interest" - previous "Value of interest"

Example below:

In position [A] of the calculated column, we do Value of interest (1881598) - Value of interest (165108), because this is the next row with the same object key.

I've tried using the EARLIER function or simple variables with Calculate and filters, but it did not succeed.

[Whitewater100 · Accepted solution]

Hi:

Can you share the data? Thanks

[Jess123]

Hi, please find the dataset sample attached (I could not manage to attach the pbix file)

dataset dax issue.xlsx

[Whitewater100 · Accepted solution]

Hi:

Can you check this out?

https://drive.google.com/file/d/1QIkzghShl21b3Dk4iamsPzYcwM3JR_42/view?usp=sharing 

Thanks..

[Jess123]

Thanks! It worked

[Whitewater100 · Accepted solution]

Hi:

Can you share the data? Thanks