compare value in one table to value in another in dax formual

[po]

Hi 

Have 2 tables empoyees and employee logins and they are joined by employee id with a 1:m relationship between them i.e. an employee can have multiple logins

employee table

id

name

employee logins

employee_id   -- this joined to eomployee.id

employee_name

datetime

...

want to compare the name in both columns to see where different.

What is best way of doing this in power bi?

just wantto use simple formual e.g calculated column and note merge tables etc or chnage tabel definitiosn as they supplied to us.

Thanks

[amitchandak · Accepted solution]

@po ,

refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8

better copy if there are 1-2 columns. If more then prefer merge in power query : https://radacad.com/append-vs-merge-in-power-bi-and-power-query

[po]

Thanks for reply but not wanting to copy data to other tables and woudl have thought coudl simply compare 2 columns in different tables without having to duplicate data in other tables?

Is it possible to do it in dax with some formula?

Thanks

[amitchandak]

@po , In case you want a column  You have to use the formula I suggest in the video in var and compare with data in current row

[po]

thanks for reply - will have a look at video