Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Check if data in 2 columns is the same (comparing email and nr for persons)

HI All,    I have a Data set with persons and 2 telephone numbers and emailadresses. I want to have an extra column which should tel me if there is a difference between those two columns for that s...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

     

    Anonymous 

    Create a custom colum in power query:

    if [tel nr 1] = [Tel nr 2] then "Yes" else "No"

     

    Same for the email columns.

     

     

    Paul Zheng _ Community Support Team
    If this post helps, please Accept it as the solution to help the other members find it more quickly.

kirbynguyen's avatar
kirbynguyen
Icon for Helper II rankHelper II
5 years ago

Anonymous Try this as a column:

 

Same = IF('Table'[tel nr 1] = 'Table'[tel nr 2], "Yes", "No")