Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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
Solved! Go to 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 ,
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
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
thanks for reply - will have a look at video
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
142 | |
75 | |
64 | |
52 | |
47 |
User | Count |
---|---|
219 | |
89 | |
73 | |
66 | |
60 |