Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
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
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 |
Please post some sample data, thank'you
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.