Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago
Solved

Check dates between two tables with multiple validations

Good afternoon, I have two tables related by a multi-to-many related ID and I need to do date checks between different tables. Example: Table 1: ID Start date End date 1 01/04/2023 10/...
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    Hi,

    You can get the yes and no with this calculated column formula in Table1

    Column = if(CALCULATE(COUNTROWS(Table2),FILTER(Table2,Table2[Programming date]>=EARLIER(Table1[Start date])&&Table2[Programming date]<=EARLIER(Table1[End date])&&Table2[ID]=EARLIER(Table1[ID])))>0,"Yes","No")

    Hope this helps.

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago

Good morning

  • The answer is 27/04 and A because it is the one that has the least difference in dates with respect to the end date 20/04 and B. If it were B and 30, the time to visit would be 20.
  • Filtering from several to many and the address is between both from table 1 to table 2 and from table 2 to table 1.
  • I would need to see both "Yes" and "No" values, although "Yes" would suffice.