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

The Fabric community is upgrading! Read all of the details including the timeline and what you can expect. 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
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.