Need help Getting LOT Numbers based of LIFO

Hi Naxyr ,

Please check:

Measure =
VAR RunningTotal =
    CALCULATE (
        SUM ( 'Table 2'[QTY] ),
        FILTER (
            ALLSELECTED ( 'Table 2' ),
            'Table 2'[CODE] = MAX ( 'Table 2'[CODE] )
                && 'Table 2'[Expiration Date] >= MAX ( 'Table 2'[Expiration Date] )
        )
    )
VAR RunningTotal_ =
    CALCULATE (
        SUM ( 'Table 2'[QTY] ),
        FILTER (
            ALLSELECTED ( 'Table 2' ),
            'Table 2'[CODE] = MAX ( 'Table 2'[CODE] )
                && 'Table 2'[Expiration Date] > MAX ( 'Table 2'[Expiration Date] )
        )
    )
VAR SIH_ =
    SUM ( 'Table 1'[SIH] )
RETURN
    IF (
        HASONEVALUE ( 'Table 2'[Expiration Date] ),
        MAX (
            IF ( RunningTotal <= SIH_, SUM ( 'Table 2'[QTY] ), SIH_ - RunningTotal_ ),
            BLANK ()
        ),
        SUM ( 'Table 1'[SIH] )
    )

Best Regards,

Icey

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