Matching Rows of two tables

[jenani_user]

Hi Team,

I have 2 tables as shown , It has equal number of rows and columns but I wanted to if it has any mismatches and get  them hightlighted. The case here is , I dont want create custom columns here as there are around 100 columns to checked.

Kindly let me know if there are any query to check table rows. If Remove matching rows would work are there any way to get the field highlighted?

INPUT:

OUTPUT

Thanks&Regards

JEN

.

[Anonymous · Accepted solution]

HI @jenani_user,

Current power bi does not support to direct compare across multiple columns.

I'd like to suggest you do unpivot columns on these fields to convert them to attribute and value.

Then you can simply use original table id and corresponds attribute field values to extract list and use table manipulation functions to compare with them.

Unpivot columns - Power Query | Microsoft Learn

Table manipulation functions (DAX) - DAX | Microsoft Learn

Regards,

Xiaoxin Sheng

[jenani_user]

Hi

can you give me an example ?