Forum Discussion

AOD's avatar
AOD
Helper III
6 years ago

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

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 Out...
Need Help DAX
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi AOD ,

 

Try creating a Column in the main table.

 

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

 

Regards,

Harsh Nathani