topic Re: Find the difference between two dates from two different tables in DAX Commands and Tips

Find the difference between two dates from two different tables

Anonymous — Wed, 07 Jun 2023 16:16:08 GMT

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[AssignmentActualFinishDate] and 'AssignmentBaselines'[AssignmentBAselineFinishDate]. The tables have a relationship many to one (*:1) and has a both cross filter direction.

The formula I have been using is:

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

The error I keep getting is "Too few arguments were passed to the DATEDIFF function. The minimum argument count for the function is 3."

I have looked through many different forum post and I have tried many different ways to solve this issue but I keep coming up short. Any help would be appreciated.

Re: Find the difference between two dates from two different tables

tamerj1 — Wed, 07 Jun 2023 17:13:52 GMT

Hi Anonymous

please try

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

Re: Find the difference between two dates from two different tables

Anonymous — Wed, 07 Jun 2023 17:17:57 GMT

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

Re: Find the difference between two dates from two different tables

Anonymous — Wed, 07 Jun 2023 17:20:19 GMT

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.

Re: Find the difference between two dates from two different tables

tamerj1 — Wed, 07 Jun 2023 17:27:56 GMT

Anonymous

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