Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I am doing five year projections my 2023 data is based off data that already exists to where my formula is the following:
Solved! Go to Solution.
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?
You'll probably have an easier time if you break things into variables.
2024 Estimate =
VAR Personnel2022 =
CALCULATE (
SUM ( 'GL298A'[BUDGET-DTL] ),
'GL298A'[FISCAL-YEAR] = 2022,
'Accounts'[Object Category] = "Personnel"
)
VAR Contractual2022 =
CALCULATE (
SUM ( 'GL298A'[BUDGET-DTL] ),
'GL298A'[FISCAL-YEAR] = 2022,
'Accounts'[Object Category] = "Contractual"
)
VAR Commodities2022 =
CALCULATE (
SUM ( 'GL298A'[BUDGET-DTL] ),
'GL298A'[FISCAL-YEAR] = 2022,
'Accounts'[Object Category] = "Commodities"
)
VAR CapitalOutlay2022 =
CALCULATE (
SUM ( 'GL298A'[BUDGET-DTL] ),
'GL298A'[FISCAL-YEAR] = 2022,
'Accounts'[Object Category] = "Capital Outlay"
)
VAR Debt2022 =
CALCULATE (
SUM ( 'GL298A'[BUDGET-DTL] ),
'GL298A'[FISCAL-YEAR] = 2022,
'Accounts'[Object Category] = "Debt"
)
VAR Personnel2023 = -2 * Personnel2022
VAR Contractual2023 = -2 * Contractual2022
VAR Commodities2023 = -2 * Commodities2022
VAR CapitalOutlay2023 = -2 * CapitalOutlay2022
VAR Debt2023 = .5 * Debt2022
VAR Personnel2024 = -3 * Personnel2023
VAR Contractual2024 = -3 * Contractual2023
VAR Commodities2024 = -3 * Commodities2023
VAR CapitalOutlay2024 = -3 * CapitalOutlay2023
VAR Debt2024 = .4 * Debt2023
RETURN
Personnel2024 + Contractual2024 + Commodities2024 + CapitalOutlay2024 + Debt2024
Ah I see. Yes thank you. I also did figured out another way kind of like the previous user stated by using a short one to have multiply by yearly assumption ie. 2024 would be 2022 numbers *1 = 2023 numbers*1 = 2024 numbers: below is what it is for personnel
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:
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.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
18 | |
7 | |
7 | |
5 | |
5 |
User | Count |
---|---|
23 | |
10 | |
10 | |
9 | |
7 |