Displaying rows with non-duplicate values

[ploweyj2]

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.

[ploweyj2]

Columns 6 + 7 compared to 10 + 11

[MattAllington · 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. 

[MattAllington]

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.