FIFO question

Hi JaviGoldstein ,
Here us my test data:

Create a calculate column

Pending Orders = 
VAR tblPO = 
    CALCULATE(
        MAX(tblPendingOrders[Amount]),
        FILTER(
            tblPendingOrders,
            tblPendingOrders[SKU] = tblSKU[SKU]
        )
    )
VAR temp_result = 
    IF(
        (tblPO-tblSKU[Balance]) >= 0,
        tblPO-tblSKU[Balance],
        0
    )
RETURN
IF(
    (temp_result - tblSKU[Balance]) > 0,
    temp_result - tblSKU[Balance],
    IF(
        tblPO > tblSKU[Balance],
        IF(
            tblSKU[Batch] = 1,
            tblSKU[Balance],
            temp_result
        ),
        temp_result
    )
)

Final output

Best regards,

Albert He

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