Forum Discussion
Calculation for dynamic target based on hystorical data
- 6 years ago
unfortinately this isn't working, "this year" is not an issue, the problem is thtat the measure not calculating an year's sum , it isshowing me an monthly sum. I attached i picture
- 6 years ago
Do you need that year sales
Year Sales = CALCULATE(TOTALYTD(sum(Sales[Sales Amount]),ENDOFYEAR('Date'[Date Filer])))This Will not give for this year(Incomplete year)
Year Sales = Var _this_year = year(TODAY()) return CALCULATE(TOTALYTD(sum(Sales[Sales Amount]),ENDOFYEAR('Date'[Date Filer]),ABS(year(Sales[Sales Date]) <> _this_year)))Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
unfortinately this isn't working, "this year" is not an issue, the problem is thtat the measure not calculating an year's sum , it isshowing me an monthly sum. I attached i picture
Do you need that year sales
Year Sales = CALCULATE(TOTALYTD(sum(Sales[Sales Amount]),ENDOFYEAR('Date'[Date Filer])))This Will not give for this year(Incomplete year)
Year Sales =
Var _this_year = year(TODAY())
return
CALCULATE(TOTALYTD(sum(Sales[Sales Amount]),ENDOFYEAR('Date'[Date Filer]),ABS(year(Sales[Sales Date]) <> _this_year)))Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.