Forum Discussion
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. I would like to have column in dashboard with Targets YTD and Target FY. I have troubles with FY Targets. There is also slicer with months.
I need to have a column which show FY value for each month ( to measure process agains full year, not only selected months).
Basically I need to see 310m for each month no matter how many months I select in slicer.
please help me on that,
many thanks,
Karolina
finally I found solution by mysleft
BP26 GOR USD FY =SUMX(ALL(DATABASE),DATABASE[BP26 GOR USD])
4 Replies
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.
Hi KaroRoza , I was able to recreate your scenario .
Please find the details .
Sales :
Target :
Date:
Measure :Sales YTD = SUM( Sales[Sales] )Target FY =CALCULATE(SUM( Targets[Target] ),REMOVEFILTERS( DimDate ))Target YTD = SUM( Targets[Target] )Variance YTD = [Sales YTD] - [Target YTD]
All months selected :
Jan and feb as selection
PBIX:
Sales Target.pbix
ThanksIf this response was helpful in any way, I’d gladly accept a kudo.
Please mark it as the correct solution. It helps other community members find their way faster
