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

[BobKoenen]

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 specific ROW

Example

Name	tel nr 1	Tel nr 2	the Same?
Joe	+444444	+444444	Yes
Jane	+333333	+333334	No
BIll	+111111	+111112	No

I want to apply the same logic to 2 email columns. Can you help me how to achieve this. I can do it in Power query or in DAX. 

Thanx

[Anonymous · Accepted solution]

@BobKoenen 

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]

@BobKoenen Try this as a column:

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