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.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

Hi,

I cannot understand the date of viit column in the third table.  For ID1, why should the answer be 27/4 for the first instance?  Why is it not 30/4?