Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Solved! Go to Solution.
CurrentYrBudget =
CALCULATE (
SUM ( PolBudget[Enviro New Business Budget] ),
PolBudget[Year] = YEAR ( TODAY () )
)
CurrentYrBudget =
CALCULATE (
SUM ( PolBudget[Enviro New Business Budget] ),
PolBudget[Year] = YEAR ( TODAY () )
)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |