Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
77
Views
Topic starter
Hi,
What way of working can we use to replace the Text formula EXACT?
would like to compare text from different columns
Kr claudine
Posted : 17/03/2020 4:36 am
Hi Claudine,
That's easy: Add a Custom Column with the following formula where Text1's column is called 'Column1' etc.
= [Column1] = [Column2]
Power Query is case sensitive so it will compare the data in the two columns and return a TRUE or FALSE.
Mynda
Posted : 17/03/2020 5:25 am
