Forum Discussion

gauravnarchal's avatar
gauravnarchal
Icon for Post Prodigy rankPost Prodigy
4 years ago
Solved

If statement (Dates)

I need help to create a calculated column in Table 1as below   If number (Table 1) =  number (Table 2)  &  Date (Table 1) Equal too and greator than the Start Date (Table 2)  and all dates that f...
Need Help
Show and Tell
  • lbendlin's avatar
    lbendlin
    4 years ago
    Column = SWITCH(TRUE(),ISBLANK(RELATED('Table 2'[Start Date])),"Error",'Table 1'[Date]<RELATED('Table 2'[Start Date]),"No",'Table 1'[Date]>EDATE(RELATED('Table 2'[Start Date]),12),"No","Yes")

     

    Note: Tables are joined via [Number].  See attached.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago
Column = SWITCH(TRUE(),ISBLANK(RELATED('Table 2'[Start Date])),"Error",'Table 1'[Date]<RELATED('Table 2'[Start Date]),"No",'Table 1'[Date]>EDATE(RELATED('Table 2'[Start Date]),12),"No","Yes")

 

Note: Tables are joined via [Number].  See attached.