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...
If you can provide a sample of your data (nothing sensitive) I will likely be able to provide a better solution for you.
I can't share the data
Table 1:
Account & Date
Table 2:
Account & Date
Relationship: Account & Account
The column that I am creating is in the Table 1, and there are more columns. I created a table with more columns ej. Name, Second Name, Account, Date table 1, date table 2
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.
