Calculate time difference between 2 date fields from separate source tables.

[AOD]

Hi , 

I want help in DAX for calculating  time difference between 2 date fields from separate source tables.

Fullname is the comman field between both the tables , Refferal sent and Outcome created are  from different tables.

Thanks for helping in advance.

AOD

[harshnathani]

Hi @AOD ,

Try creating a Column in the main table.

Column = DATEDIFF( 'Table'[Referal Sent], RELATED('Table' [Outcome Created]), DAY)

Regards,

Harsh Nathani

[lbendlin]

Where are you stuck?   Are the tables linked with a relationship on fullname? can you show the data model?