topic Re: Calculate time difference between 2 date fields from separate source tables. in DAX Commands and Tips

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

AOD — Mon, 03 Aug 2020 14:38:33 GMT

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

lbendlin — Mon, 03 Aug 2020 16:05:08 GMT

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

Anonymous — Tue, 04 Aug 2020 06:49:45 GMT

Hi AOD ,

Try creating a Column in the main table.

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

Regards,

Harsh Nathani