Forum Discussion
Datediff between date and minimum date
Hi Anonymous
can you provide the sample data for both the tables??
would be easier for us to give you proper answer.
No sorry, it is confidential information.
Hi Anonymous
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.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
Hi Anonymous
Please create the following measure:
difference = Datediff( Min(Transcation date), Max(Release date),day)Let me know whether you are getting desired result of not.
If my post helps please give kudos and accept it as a solution!
Thanks
See below dataset as an example
Uzi2019, can you please have a look? thanks in advance