Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Find the difference between two dates from two different tables

I am looking to find the difference between two dates from two different tables. The tables being used are Assignments and AssigmentBaselines. The columns used are 'Assignments[AssignmentActualFinish...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi Anonymous 

    please try

    Baseline Days +/- =
    DATEDIFF (
    AssignmentBaselines[AssignmentBaselineFinishDate],
    RELATED ( Assignments[AssignmentActualFinishDate] ),
    DAY
    )

tamerj1's avatar
tamerj1
Community Champion
3 years ago

Hi Anonymous 

please try

Baseline Days +/- =
DATEDIFF (
AssignmentBaselines[AssignmentBaselineFinishDate],
RELATED ( Assignments[AssignmentActualFinishDate] ),
DAY
)

Anonymous's avatar
Anonymous
Not applicable
3 years ago

I am no longer getting any errors, but the data is not auto filling into the columns. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    I guess it just took some time. As of right now, it seems like that fixed the issue. Thank you for the help. I was banging my head against the wall for too long. 

    • tamerj1's avatar
      tamerj1
      Community Champion
      3 years ago

      Anonymous 

      This is a bug in the latest update. Just manually resize the column and the values should appear.