Forum Discussion
Projection Based off Calculated Field
I am doing five year projections my 2023 data is based off data that already exists to where my formula is the following: 2023 Estimate: = CALCULATE( SUM('GL298A'[BUDGET-DTL] ),'GL298A'[FISCAL...
That's why I put the Xxx2023 variables inside the measure and then referenced them from the Xxx2024 variables. Change the -3s I had to -1s and it should be close to what you're after.
Hi:
Can you just use the same measure for 2024 as 2023 but add and extra * _ at the end. If no change just multiply the 2023 forumla by 1. If 5% lower multiply by .95?