Forum Discussion
Compare two dates from different tables, using if condition
I have two tables, Table 1 and Table 2, both are related based on account number. I want to compare if date from table 1 = date from table 2, if is not the same then "different" is it is the same...
Hi,
Share some dummy data and show the expected result.
| TABLE 1 | TABLE 2 | RESULT | ||||
| Account | Date | Account | Date | Result | ||
| 765A | 1/1/2022 | 765A | 11/12/2023 | FALSE | ||
| 987D | 5/7/2023 | 987D | 4/5/2023 | FALSE | ||
| 036G | 9/2/2023 | 036G | 9/2/2023 | TRUE | ||
| 872B | 9/9/2023 | 872B | 9/9/2023 | TRUE | ||
| 926K | 4/5/2023 | 926K | 1/1/2022 | FALSE | ||
| 047A | 6/1/2023 | 047A | 6/1/2023 | TRUE | ||
| 102M | 2/3/2023 | 102M | 2/3/2023 | TRUE | ||
| 094K | 7/8/2022 | 094K | 9/9/2023 | FALSE | ||
| 237V | 5/7/2023 | 237V | 12/5/2023 | FALSE |
Hi,
In Table1, write this calculated column formula
Column = if(CALCULATE(min(Table2[Date]),FILTER(Table2,Table2[Account]=EARLIER(Table1[Account])))=Table1[Date],"Same","Different")Hope this helps.