Forum Discussion

gauravnarchal's avatar
gauravnarchal
Post 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
Super 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.