topic Re: Matching Rows of two tables in Developer

Matching Rows of two tables

jenani_user — Tue, 12 Dec 2023 09:22:26 GMT

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

Re: Matching Rows of two tables

Anonymous — Thu, 14 Dec 2023 07:35:36 GMT

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

Re: Matching Rows of two tables

jenani_user — Wed, 20 Dec 2023 10:54:55 GMT

can you give me an example ?