Filtering value based on next closest date

Hi zuzaarbuza 

See if the following DAX statement for calculated column works for:

Next route = 
VAR RegistrationPlate = RouteTable[Registration plate]
VAR UnloadingDate = RouteTable[Unloading date]
RETURN
    MAXX (
        
        TOPN ( 1,
            FILTER (
                RouteTable,
                RouteTable[Registration plate] = RegistrationPlate
                    && RouteTable[Unloading date] > UnloadingDate
                    && RouteTable[Loading date]
                        <= DATE ( YEAR ( UnloadingDate ), MONTH ( UnloadingDate ), DAY ( UnloadingDate ) + 2 )
            ),
            RouteTable[Loading date], ASC
        ), RouteTable[Route]
    )

Let us know if that was helpful.

Best

David