Inventory Month on Month comparison

Hi Brewster0101 ,

I think you can try code as below to create measures.

Previous Data by SKU = 
VAR _PREVIOUSVALUE =
    CALCULATE (
        MAX ( 'Table'[Month (Date)] ),
        FILTER (
            ALLEXCEPT ( 'Table', 'Table'[SKU/ID] ),
            'Table'[Month (Date)] < MAX ( 'Table'[Month (Date)] )
        )
    )
RETURN
    CALCULATE (
        SUM ( 'Table'[Value ] ),
        FILTER (
            ALLEXCEPT ( 'Table', 'Table'[SKU/ID] ),
            'Table'[Month (Date)] = _PREVIOUSVALUE
        )
    )

Diff = CALCULATE(SUM('Table'[Value ])) - [Previous Data by SKU]

Change Percentage = 
DIVIDE([Diff],[Previous Data by SKU])

Result is as below.

Best Regards,
Rico Zhou

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