YoY Growth Calculation - Dataflow

Efraim · 2025-03-25T11:52:21+00:00

There was an error rendering this rich post.

Hello,

I am trying to create a dataflow that would apply a % growth YoY (See example table below with 2% YoY growth).

There would be a data entry say on 2025 and then it will trigger the YoY Growth calculation. I tried using the "Period by period recursion" but it is applying the % growth on MoM.

Can anyone please help on how to set up the dataflow so it would calculate YoY growth instead of the MoM?

Staff	2025	2026	2027
Staff 1	100,000	102,000	104,040

Find more posts tagged with

Dataflow

Accepted answers

Bart Scott

If you cube is structured by month entity the period -1 is 1 one month prior. You can either do the Prior Year on the first Block, or a Period -12 (if you only have 12 months).

Hope that helps.

Bart Scott

CFO Solutions LLC

Hamza Mesbahi

Hi @Efraim,

As Bart correctly explained above, the "Offset" function will reference a specified number of periods based on the dimensions of your cube. In your case, since the cube is dimensioned by Month, you'll need to set the offset to -12 in order to reference the same month from the previous year for each Month in the cube. If your cube were dimensioned by Year, an offset of -1 would suffice.

Kind regards,

Hamza

All comments

Bart Scott

If you cube is structured by month entity the period -1 is 1 one month prior. You can either do the Prior Year on the first Block, or a Period -12 (if you only have 12 months).

Hope that helps.

Bart Scott

CFO Solutions LLC

Hamza Mesbahi

Hi @Efraim,

Kind regards,

Hamza

Efraim

Hello both, thanks for the answer!

I used the -12 offset and it's working now when "Period by period recursion" is used