Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
Solved! Go to 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.
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.
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.
User | Count |
---|---|
129 | |
73 | |
70 | |
58 | |
53 |
User | Count |
---|---|
190 | |
97 | |
67 | |
63 | |
54 |