Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

compare two Excel files

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 "ti...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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.