Question Re: SAC - Create Date Variance Calculation in Technology Q&A

SAC - Create Date Variance Calculation

jonasvorwerg — Mon, 27 Sep 2021 06:28:57 GMT

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 — Mon, 27 Sep 2021 07:04:31 GMT

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 — Mon, 27 Sep 2021 07:10:26 GMT

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 — Mon, 27 Sep 2021 07:33:54 GMT

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

jonasvorwerg — Mon, 27 Sep 2021 09:03:35 GMT

Hi william.yu

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