Budget figures getting double due to multiple years. How to get the budget for each year without sum

[Anonymous]

Hi Experts,

I have an issue with my report where the requirement is to display the budget values for YTD , and the data has two years 2021 and 2022. And as per YTD it must only show for 2022. But i am getting the values summed as below:

expected result

for example if the value in 2021 is 10000 and in 2022 is 20000 then it must show values for 2022 i.e. 20000. But its getting summarized and giving result 30000.

I have drafted formulae but hard coded it:

CurrentYrBudget = CALCULATE(SUM(PolBudget[Enviro New Business Budget]),PolBudget[Year]=2022)

Hard coding is not correct, how this can be done dynamically, please help.

Thanks

Vaibhav

[johnt75 · Accepted solution]

CurrentYrBudget =
CALCULATE (
    SUM ( PolBudget[Enviro New Business Budget] ),
    PolBudget[Year] = YEAR ( TODAY () )
)