Forum Discussion

KaroRoza's avatar
KaroRoza
Helper I
5 months ago
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...
Need Help
  • KaroRoza's avatar
    KaroRoza
    5 months ago

    finally I found solution by mysleft

    BP26 GOR USD FY =
        SUMX(ALL(DATABASE),DATABASE[BP26 GOR USD])
Natarajan_M's avatar
Natarajan_M
Super User
5 months ago

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


Thanks 
If 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