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.
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.