Re: Calculate time difference between 2 date field...

AOD · ‎08-03-2020

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 · ‎08-03-2020

Hi @AOD ,

Try creating a Column in the main table.

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

Regards,

Harsh Nathani

lbendlin · ‎08-03-2020

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

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