Calculating SUM for the previous last month

[NChamroo]

Hello Experts, 

I have a data set, the actuals and forecast value are in the same column and I am trying to get the Sum of Actuals by month and YTD for the previous months. I need to exclude the current month and the remaining year months. My below formula is returning the total instead of the monthly when I am adding the measure in a matrix. 

Actual BHR (UC) =

CALCULATE(

    SUM('Actual_Forecast[Block Hour]'[Block Hours]),

    FILTER(

        ALL('Calendar Date'[Date].[Date]),

        'Calendar Date'[Date].[Date] < EOMONTH(TODAY(), -1) &&

        'Calendar Date'[Date].[Date] >= DATE(YEAR(TODAY()), 1, 1)

    )

)

[bhanu_gautam · Accepted solution]

@NChamroo  It looks like syntax error can you try with below mentioned DAX once

Actual BHR (UC) = CALCULATE(
SUM('Actual_Forecast'[Block Hours]),
FILTER(
ALL('Calendar Date'[Date].[Date]),
'Calendar Date'[Date].[Date] < EOMONTH(TODAY(), -1) &&
'Calendar Date'[Date].[Date] >= DATE(YEAR(TODAY()), 1, 1)
)
)

[NChamroo]

Thanks Gautam, thats perfect

[bhanu_gautam]

@NChamroo Please accept this as solution if it helped you