Using DAX to selectively pick 1 Day value from a list of possible matching days.

rainynights ,

Create a calculate column using dax below:

Nearest Day = 
VAR Product_Type = 'Product Received Day'[Product Type]
VAR Received_Day_Number = 'Product Received Day'[Received Day number]
VAR Nearest_Day_Number_Later =
    CALCULATE (
        MIN ( 'Shipment Days'[Shipment Day Number] ),
        FILTER (
            'Shipment Days',
            'Shipment Days'[Shipment Day Number] >= Received_Day_Number
                && 'Shipment Days'[Product Category] = Product_Type
        )
    )
VAR Nearest_Day_Number =
    IF (
        Nearest_Day_Number_Later <> BLANK (),
        Nearest_Day_Number_Later,
        CALCULATE (
            MIN ( 'Shipment Days'[Shipment Day Number] ),
            FILTER ( 'Shipment Days', 'Shipment Days'[Product Category] = Product_Type )
        )
    )
RETURN
    SWITCH (
        Nearest_Day_Number,
        1, "Monday",
        2, "Tuesday",
        3, "Wednesday",
        4, "Thursday",
        5, "Friday",
        6, "Saturday",
        7, "Sunday"
    )

You can also refer to the pbix file attached.

Community Support Team _ Jimmy Tao

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