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.

MohammadLoran25's avatar
MohammadLoran25
Solution Sage
3 years ago

Hi Syndicate_Admin ,

I do not understand your output. Isn't it wrong?

 

1-Why visit type A for ID 1 is not in the output?

 

2-How is your relationship crossfiltering behavior? Both? From Table 1 to Table 2 or table 2 to table 1?

 

3- You want to see only the "YES" values? Please provide exact output based on your sample data.

 

Regards,

Loran