Forum Discussion

PR1762's avatar
PR1762
New Member
2 years ago

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

Need Help

2 Replies

  • PR1762's avatar
    PR1762
    New Member
    2 years ago

    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