Cumulative Totals - exclude most recent months values

[mike_I]

I am plotting cumulative actuals against a forecast. However,  I only want to plot the actual results up until  the previous month we have actuals for. This excludes issues with having partial months actuals. So if for example  our most recent actual result  was on the 1st of April 2018, I only want include  results up  until  March 2018.

I am able to create the base plot (see screenshot below), but I can't figure out how to exclude the most recent month (April).

Here is my code,

Cumulative Actuals_forum3 = IF( LASTDATE( 'DateDim'[Date]) > [Max Month with Actuals],
    BLANK(),
        CALCULATE(( Detailed_Breakdown[Actuals.]),
            FILTER( ALLSELECTED( 'DateDim' ), 
                'DateDim'[Date] <= MAX( 'DateDim'[Date])))

 )

 I would have though that I could have subtracted one month from the  [Max month with Actuals]  measure- but that doesn't work.  Here is my Measure that subrtacts one month 

Max Month with Actuals - 1 month = EDATE([Max Month with Actuals],-1)

Any ideas or suggestions would be welcome. 

Demo file here 

Cheers !

[v-chuncz-msft · Accepted solution]

@mike_I,

You may try to change it as follows.

IF (
    LASTDATE ( 'DateDim'[Date] )
        >= CALCULATE ( [Max Month with Actuals], ALLSELECTED ( 'DateDim'[Date] ) ),