Calculated column varying result for each row depending on dates and item within the same table

Hi Ibendlin, thank you for your response.

In the aim of simplifying the problem, I showed an example of a Well having a near-perfect exponential production history, but this is far from being the common case: Producing wells often show very complex changes of trends in their production, sometimes increasing and sometimes decreasing. The causes of these changes are many, such as:

• Techniques used to maintain or even increase oil reservoir rock pressure (i.e. water injection) can produce increments (negatives DNAs).
• When these techniques suffer a failure, the DNAs can change drastically to double the previous value.

The following image is real data of a well, where the variability of DNA can be observed.

Then, the entire production history of a well can not be characterized by a single DNA value. Instead, DNAs are estimated all across the life of a producing well, because is a measure of the well is performing in comparison with expectations, or other similar wells.

The problem I'm trying to solve is related to how to use each row date as a parameter, instead of using MAX(data[Date]).

Thanks again for your help.

Best regards,

Marcelo