Forecasting beginning month inventory based on usage forecast

Hi chad_clift ,

According to your description, it's related to your measure formula. I create a sample and here's my solution.

Create a measure.

BOM Forecast =
VAR _Lastnonblank =
    MAXX (
        FILTER ( ALL ( 'Table' ), 'Table'[BOM on hand] <> BLANK () ),
        'Table'[Month]
    )
RETURN
    IF (
        MAX ( 'Table'[BOM on hand] ) <> BLANK (),
        MAX ( 'Table'[BOM on hand] ),
        MAXX (
            FILTER ( ALL ( 'Table' ), 'Table'[Month] = _Lastnonblank ),
            'Table'[BOM on hand]
        )
            - SUMX (
                FILTER (
                    ALL ( 'Table' ),
                    'Table'[Month] >= _Lastnonblank
                        && 'Table'[Month] <= MAX ( 'Table'[Month] )
                ),
                'Table'[Usage Actual/Forecast]
            )
    )

Get the correct result.

I attach my sample below for reference.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.