Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
jenani_user
Frequent Visitor

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:

jenani_user_0-1702370449917.png

 

OUTPUT

jenani_user_1-1702370541341.png

Thanks&Regards

JEN

.

 

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

2 REPLIES 2
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Hi

can you give me an example ?

 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.