SAC - Create Date Variance Calculation

[#1]

Hello everyone,

I was wondering if there is a way to calculate a time variance that is dynamically created for each time period.

February Value = Original Feb Value - Original Jan Value

March Value = Original March Value - Original Feb Value

I could only find the Lookup function, this however, allows me only to choose a specific month and not iterate it over each month.

Some help or advises from your side would be highly appreciated.

Best regards

[jonasvorwerg]

Hi William,

thanks for your response. Would that not only create a key measure for September 21 - August 21 but not for each month in the past?

[William_Yu1]

If you time granularity is on day, then you first need a MTD, then a MTD of previosu period ,and then MTD - MTD Previous.