Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi.
I have a table. I need to be able to filter out the matches against non matches and conditionally format the 'True'
Here is my table.
and this is the result I would like to acheive
Solved! Go to Solution.
Hi! In Power Query, I would make a new custom column that is the difference of A and B, then create a conditional column that specifies if the new custom column = 0, True, else, False.
You could also skip adding the column that calculates 0 or not and just do a conditional column that looks to see if the value in one column is equal to another. You'll get the same TRUE/FALSE this way as well, but you won't have the additional step of the other column.
Proud to be a Super User! | |
Hi! In Power Query, I would make a new custom column that is the difference of A and B, then create a conditional column that specifies if the new custom column = 0, True, else, False.
You could also skip adding the column that calculates 0 or not and just do a conditional column that looks to see if the value in one column is equal to another. You'll get the same TRUE/FALSE this way as well, but you won't have the additional step of the other column.
Proud to be a Super User! | |
Excellent - Thank you so much!
You are very welcome!
Proud to be a Super User! | |
User | Count |
---|---|
93 | |
83 | |
77 | |
71 | |
65 |
User | Count |
---|---|
114 | |
101 | |
96 | |
65 | |
60 |