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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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.

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.

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.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

April Fabric Community Update

Fabric Community Update - April 2024

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

March 2024 PBI Gallery Image

Power BI Monthly Update - March 2024

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