Forum Discussion

Frequent Visitor

2 years ago

Solved

Matching Rows of two tables

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

Anonymous
2 years ago
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

Anonymous

Not applicable

2 years ago

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