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.
Okay this makes sense and it is much cleaner and easier, but I need one more step. Based off using your formula above I need another calculation on the sidebar. For example I would use:
2024 Estimate =
VAR Personnel2024 = -1 * 'Yearly Budget'[2023 Estimate:]
VAR Contractual2024 = -1 * 'Yearly Budget'[2023 Estimate:]
VAR Commodities2024 = -1 * 'Yearly Budget'[2023 Estimate:]
VAR CapitalOutlay2024 = -1 * 'Yearly Budget'[2023 Estimate:]
VAR Debt2024 = -1 * 'Yearly Budget'[2023 Estimate:] VAR OtherPayments2024 = -1 * 'Yearly Budget'[2023 Estimate:]
RETURN
Personnel2024 + Contractual2024 + Commodities2024 + CapitalOutlay2024 + Debt2024 +OtherPayments2024 (and so on for following years)
However, when I do this the "yearly budget[2023 Estimate:] is not filtering off the codes such as debt contractual, etc. Is it possible to write the second DAX with filtering by those expense types???
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.