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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
ploweyj2
Frequent Visitor

Displaying rows with non-duplicate values

I am trying to create a query/table that will only display the rows that have different values for certain colums. I need to identify which cases have a different pathologic diagnosis before and after surgery along with the corresponding assesion number. Table looks something like this

 

Column 1           Column 6                 Column 7               Column 10              Column 11

Assession #  Pre-Op Diagnosis  PreOp Tumor Type Post-Op Diagnosis Post-Op Tumor Type  etc.

SMM18-001  BCC                      nodular                    BCC                        Nodular

SMM18-002  BCC                      infiltrative                 BCC                        Nodular and Superficial

 

I have searched online for an reasonable answer to solve this but have not been able to locate anything.  Any assistance would be greatly appreciated.

 

1 ACCEPTED SOLUTION

So add a custom column in Power Query. It will be something like

 

= if [column 6] = [column 10] and [column 7] = [column 11] then “Same” else “not same”

 

then filter the new column. 

 

Make sure you use use the custom column UI to get the right capitalisation of the column names. 



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.

View solution in original post

3 REPLIES 3
ploweyj2
Frequent Visitor

Columns 6 + 7 compared to 10 + 11

So add a custom column in Power Query. It will be something like

 

= if [column 6] = [column 10] and [column 7] = [column 11] then “Same” else “not same”

 

then filter the new column. 

 

Make sure you use use the custom column UI to get the right capitalisation of the column names. 



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.
MattAllington
Community Champion
Community Champion

Which columns?  In Power Query you can create a custom column to test if values in 2 columns are the same, and return true or false, then filteron that column. 



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.