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