Forum Discussion
Solved
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 afte...
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.
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.