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

[William_Yu1 · Accepted solution]

Hi jonasvorwerg,

You can achieve this with cross calculation.

1. You can default measure: A = current month value

2. Create a cross calculation: B with restricte measure by navigation previous period

3. Create a cross calculation C( display value) = A - B.

Best regards, William

[jonasvorwerg]

Hi william.yu

I think this does not solve the problem. I need more something like a cumulated sum.

[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.