Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
70 | |
38 | |
27 | |
26 |
User | Count |
---|---|
98 | |
96 | |
60 | |
44 | |
40 |