Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
po
Post Prodigy
Post Prodigy

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

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

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

4 REPLIES 4
amitchandak
Super User
Super User

@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

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

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

@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

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

thanks for reply - will have a look at video

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.