Match Closest Length to Existing Available Length Between Two Tables

heiligbd,

Try these calculated columns in Table1:

Matched Batch = 
VAR vMaterial = Table1[Material #]
VAR vLengthOrdered = Table1[Length Ordered]
VAR vInventory =
    FILTER (
        Table2,
        Table2[Material #] = vMaterial
            && Table2[On Hand Length] >= vLengthOrdered
    )
VAR vMinOnHandLength =
    MINX ( vInventory, Table2[On Hand Length] )
VAR vMinBatch =
    MINX (
        FILTER ( vInventory, Table2[On Hand Length] = vMinOnHandLength ),
        Table2[Batch]
    )
VAR vResult =
    IF ( ISBLANK ( vMinBatch ), "No Match", CONVERT ( vMinBatch, STRING ) )
RETURN
    vResult

On Hand Length = 
VAR vMaterial = Table1[Material #]
VAR vLengthOrdered = Table1[Length Ordered]
VAR vInventory =
    FILTER (
        Table2,
        Table2[Material #] = vMaterial
            && Table2[On Hand Length] >= vLengthOrdered
    )
VAR vMinOnHandLength =
    MINX ( vInventory, Table2[On Hand Length] )
VAR vResult =
    IF ( ISBLANK ( vMinOnHandLength ), "No Match", CONVERT ( vMinOnHandLength, STRING ) )
RETURN
    vResult

Awesome! Worked like a Champ! Thanks so much!