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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
PR1762
New Member

Search Two Tables by using Two Columns

I am looking for some advise on how in Power Query I can return a True or False value in a new column in one Table Based on a Search on two columns in that table,  against the same two columns in another table.

 

i have the same data in two tables however one of the tables has newer data in it, it is the new data I am looking at marking as Ture.

 

thanks in advance, Paul

2 REPLIES 2
PR1762
New Member

In the table below there are two customer I would like to check all dates to see if there is any change to each date in the second table, however when checking the dates I want to ignore the records where there is a null against a date as this illustrates that no change in dates.  So the first customer would get a false against the filter Keep Record,  however the second customer would have a true set, as the T2.Logon Date has a change to the record in the first table.

 

 

Customer ID

 

123456789

 

987654321

T1.Registered Date

 

01/01/2023

 

01/01/2023

T1.Start Date

 

01/02/2023

 

01/02/2023

T1.Order Date

 

01/03/2023

 

01/03/2023

T1. Logon Date

 

Null

 

Null

T2.Registered Date

 

Null

 

Null

T2.Start Date

 

Null

 

Null

T2.Order Date

 

01/02/2023

 

Null

T2. Logon Date

 

Null

 

01/04/2023

Keep Record

 

FALSE

 

TRUE

 

serpiva64
Solution Sage
Solution Sage

Please post some sample data, thank'you

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.