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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Olamum
Helper II
Helper II

Find new addresses, retired and existing

Hello Everyone,

I have a request regarding obtaining new addresses by utilizing two tables: one containing the existing list and the other comprising the updated list provided by the vendor. The objective is to compare these lists in order to identify:

  1. Addresses that are present in both the existing and updated lists (considered as existing).
  2. Addresses in the updated list that are not found in the existing list (considered as new addresses).
  3. Addresses in the existing list that are not present in the updated list (considered as retired and should be removed).

The updated list encompasses both new and existing addresses.

Thanks All!

Find the link below.

 

https://docs.google.com/spreadsheets/d/1J13bHevZ_to7aLxLm0S9beSqRoQFeeZG/edit?usp=sharing&ouid=11513...

1 ACCEPTED SOLUTION

Hi,

Try the various types of Joins in Power Query.  There are ample Youtube videos you can watch on understanding these joins.  DIY.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

4 REPLIES 4
Olamum
Helper II
Helper II

@Ashish_Mathur  Please help 

 

Hi,

Try the various types of Joins in Power Query.  There are ample Youtube videos you can watch on understanding these joins.  DIY.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Thanks for your help very much

You are welcome.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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