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 "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 

 

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.

1 Reply

  • 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.