Data Processing for Actual and Forecast data

Sorry, does your table only contain the data you have provided?

If you have a date table, can you please share it? together with any other tables.
"the Actual spend is being populated" Where from?

"I have a Date filter using the Date table to filter out the Month End". What does this mean exactly?

Please provide an example as a table of what you are expecting to achieve. I can't figure out what the charts are calculating.

Thanks.

Hi Malsk1_1 ,

I created a sample pbix file(see attachment), please check whether that is what you want.

1. Create a calculated column as below

nForecast Spend =
VAR _predate =
    CALCULATE (
        MAX ( 'Table'[Month End] ),
        FILTER ( ALL ( 'Table' ), 'Table'[Month End] < EARLIER ( 'Table'[Month End] ) )
    )
VAR _preforecast =
    CALCULATE (
        MAX ( 'Table'[Forecast Spend] ),
        FILTER (
            ALL ( 'Table' ),
            'Table'[Month End] = _predate
                && 'Table'[Forecast Period] = EARLIER ( 'Table'[Forecast Period] )
        )
    )
RETURN
    IF ( ISBLANK ( _predate ), 'Table'[Forecast Spend], _preforecast )

2. Created a clustered column chart

Best Regards