compare two Excel files

[Anonymous]

Hi,

I wish to compare two Excel files, "reference file" and "check file". In this file, "title 1" is the main reference. "Title 2" is a set of modules that belongs to the "title 1" number, and "title 3" is the serial number of the "title 2" modules. I want to see only the errors between my "reference file" and "check file".

This is a example 

[Anonymous · Accepted solution]

Hi @Anonymous 

You can create a calculated column in 'check file' table

Checker =
VAR a =
    MAXX (
        FILTER (
            'reference file',
            [Title 1] = EARLIER ( 'check file'[Title 1] )
                && [Title 2] = EARLIER ( 'check file'[Title 2] )
        ),
        [Title 3]
    )
RETURN
    IF ( [Title 3] = a && a <> BLANK (), "Yes", "No" )

Output

Best Regards!

Yolo Zhu

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