Forum Discussion
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 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
.
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
2 Replies
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
Hi
can you give me an example ?
