Forum Discussion

silverdale9999's avatar
silverdale9999
Helper I
5 years ago
Solved

Maximum Date Custom Column - Compare 2 dates in different tables

Hi everyone!   Trying to get my head around this and not getting very far!   I have 2 tables - Problem, and Task.  The two are related via Problem ID.  Each Problem will have multiple tasks.   ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    silverdale9999 - Should be:

    Column =
  VAR __Other = MAXX(RELATEDTABLE('Table2'),[Task Last Modified Date])
RETURN
  MAXX( {[Last Modified Date], __Other },[Value])
Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

silverdale9999 - Should be:

Column =
  VAR __Other = MAXX(RELATEDTABLE('Table2'),[Task Last Modified Date])
RETURN
  MAXX( {[Last Modified Date], __Other },[Value])
  • silverdale9999's avatar
    silverdale9999
    Helper I
    5 years ago

    That works perfectly ! Thanks so much for taking the time to reply.