DAX for finding matches in multiple columns

You could create a calculated column like

Match =
VAR DateToCheck =
    RIGHT ( 'Table'[Column1], 10 )
VAR NumberToCheck =
    LEFT ( 'Table'[Column1], 20 ) -- Replace the logic here as needed
VAR AllSerialNos =
    CALCULATETABLE ( ALL ( 'Table'[Column2] ), 'Table'[Column4] = DateToCheck )
VAR AllBatchNos =
    CALCULATETABLE ( ALL ( 'Table'[Column3] ), 'Table'[Column4] = DateToCheck )
VAR Result =
    IF (
        NumberToCheck
            IN AllSerialNos
                || NumberToCheck IN AllBatchNos,
        "Match",
        "Discrepancy"
    )
RETURN
    Result

You'll need to change the logic splitting out the number from the date appropriately, and you may need to manipulate the date data to get it in date format to match Column4