Reply
Frequent Visitor
Posts: 3
Registered: ‎12-07-2018
Accepted Solution

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.

 


Accepted Solutions
Highlighted
Super User
Posts: 1,627
Registered: ‎07-03-2015

Re: Displaying rows with non-duplicate values

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 a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

View solution in original post


All Replies
Super User
Posts: 1,627
Registered: ‎07-03-2015

Re: Displaying rows with non-duplicate values

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 a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
Frequent Visitor
Posts: 3
Registered: ‎12-07-2018

Re: Displaying rows with non-duplicate values

[ Edited ]

Columns 6 + 7 compared to 10 + 11

Highlighted
Super User
Posts: 1,627
Registered: ‎07-03-2015

Re: Displaying rows with non-duplicate values

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 a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.