Forum Discussion

chris_staines's avatar
chris_staines
Frequent Visitor
8 years ago

DATEDIFF across twotables

Hello,   Can anyone help me with what I hope is a straight forward question please?   I have 3 related tables:  Items; unique records desribing the item, related to both Transactions and Outcome...
Need Help
chris_staines's avatar
chris_staines
Frequent Visitor
8 years ago

Hello Daniel,

 

Ideally, yes that is what I would like to be able to do. In the case of the multiple dates, if it is possible to select the first outcome *after* the transaction date that would be great.

 

I managed to get a result using MIN or MAX, which for some cases should be fine, but where there are multiple entries for the same item it can obviously give the wrong result...

 

Please follow this link for my example pbix file: https://drive.google.com/open?id=1wYY-um8g7rCLBGFm8M2Y02JaWNXEptjY

 

Many thanks,

Chris

 

 

v-danhe-msft's avatar
v-danhe-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi chris_staines,

From your description, I could not undestand the sntence "if it is possible to select the first outcome *after* the transaction date", if I selecet the first data like the picture below (2018/1/25), the related tranaction data should be with the Item name? What about the second date(the second 2018/1/25) shoud be related to which dat? Could you please post your desired result if possible?

 

Regards,

Daniel He