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])
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi,

There might be a better way to do this but at the top of my head this works.

 

Update_Date =

VAR _new = CALCULATE(MAX('TaskTable'[TaskUpdateDate]),RELATEDTABLE(ProblemTable))

Return

if (_new < 'ProblemTable'[ProblemModifiedDate],'ProblemTable'[ProblemModifiedDate],_new)
 

You can add isblank() if you need.