Two Tables unrelated need Column added with results of lookup

[EZimmet]

2 Tables from two different sources no relationship link between them

• TABLE_1 – Holds info for Physical Assets
• TABLE_2 – Holds info for Software, VM’s Physical Assets Ect…

I've done the following DAX to look for mismatches in the Serial Number Field.   – Works fine as some are flagged   

 _Find SN TABLE_1 to TABLE_2  = IF  (TABLE_1[SerialNum]  IN DISTINCT  (TABLE_2[SERIAL_NUMBER])  , 1, 0 )

Need help on this next step

With your assistance I need a New Column added to TABLE_1 populated with the mismatched data from TABLE_2 to send off for validation.

[smpa01]

@EZimmet 

calculatedColumninT1 = CALCULATE(MAX(t2[valueToReturn]),TREATAS(VALUES(t2[columnToLookup]),t1[columnToLookup]))

[EZimmet]

calculatedColumninT1 =

TABLE_1[SerialNum]

=

CALCULATE(MAX(TABLE_2[SERIAL_NUMBER]

),

TREATAS(VALUES(TABLE_2[SERIAL_NUMBER]

),

TABLE_1[SerialNum]

))

-------------------------

I get this in TABLE_1

[smpa01]

Sorry, this should be the one

Column = t1[Column1]=CALCULATE(CALCULATE(MAXX(t2,t2[Column1]),TREATAS(VALUES(t1[Column1]),t2[Column1])))

[EZimmet]

This is the format I need a New Column added showing the bad Serial Number 

[smpa01 · Accepted solution]

@EZimmet  something like this, pbix is attached

Column =
CALCULATE (
    MAXX ( t2, t2[Column1] ),
    TREATAS (
        {
            IF (
                t1[sn]
                    <> CALCULATE (
                        CALCULATE (
                            MAXX ( t2, t2[sn] ),
                            TREATAS ( SUMMARIZE ( t1, t1[Column1], t1[sn] ), t2[Column1], t2[sn] )
                        )
                    ),
                t1[sn]
            )
        },
        t2[sn]
    )
)