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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.