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
    )

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.