Datediff between date and minimum date

Question

Hi,&nbsp;I have two tables. First table contains workorder information. Second table contains material transations information. Join is on workorder ID and operation sequence number. I try to compare the release date from the workorder table with the MINIMUM transaction date from the materials transactions table. Return should be the number of days difference. For some reason I cannot compare both dates in the different tables, Power BI does not find direct relationship. Can anyone help?&nbsp;Thanks in advance.&nbsp;&nbsp;&nbsp;

uzi2019 · Answer

Hi&nbsp;Anonymous&nbsp;can you provide the sample data for both the tables??would be easier for us to give you proper answer.

anonymous · Answer

No sorry, it is confidential information.

uzi2019 · Answer

Hi&nbsp;Anonymous&nbsp;No problem.Can you provide the just sample data take same no of columns and change the values of a columns. And share both the files just screen shot of 4 to 5 records.

anonymous · Answer

Hi, see both tables for an example. Join_ID 5465083-100 can be used as an example. Once listed in the first table, multiple times in the second (transaction table). Outcome should be days difference between the minimum transaction date of the second table and the release date of the first table, by Join ID. Thanks in advance

anonymous · Answer

See below dataset as an example

Forum Discussion

Datediff between date and minimum date

9 Replies

Related content

DATEDIFF DAX

Minimum datediff per unique value

DATEDIFF Working Days

DATEDIFF

DateDiff Incorrect output