Forum Discussion
Solved
FY data for each month
Hi, please help on that as I still can not get results which I expect to see. This is very simple one dataset. I have sales records for all months (now 1-2.2026) and Targets for each month of 2026...
finally I found solution by mysleft
BP26 GOR USD FY =SUMX(ALL(DATABASE),DATABASE[BP26 GOR USD])
Target FY =
VAR SelectedYear = SELECTEDVALUE(Dates[Year], YEAR(TODAY()))
RETURN
CALCULATE(
SUM(Targets[Annual Target]),
ALL(Dates[Month]),
Dates[Year] = SelectedYear
)
I'd suggest making a date table and then using a formula similar to the one here. The key is that you need to use ALL() to ignore the month filter.