Data Load - Calculate the difference between cumulative values

[jerryr125]

Hi - 

I am not entirely sure if the following can be accomplished.

On the data load, I would like to calculate the difference between values instead of the cumulative value.

That is, by date and location, determine the difference in quantity between the two dates.

Example:

Therefore, the OUTPUT is the results I am attempting to achieve for the data load.

Any thoughts ? 

Thanks - Jerry

[JuanGerardo · Accepted solution]

Hi @jerryr125 , you can use the Previous() function to calculate this difference:

Output:

Load

   Date,

   Location,

   If(Location = Previous(Location), [Quantity Sold Cummulative] - Previous([Quantity Sold Cummulative]), [Quantity Sold Cummulative]) AS [Quantity Sold]

Resident Input  // Or from your data connection

Order by Location, Date;

JG

[jerryr125]

Thank you - perfect ! Jerry