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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors