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 Outcome created are  from different tables.

 

Thanks for helping in advance.

AOD

Need Help DAX

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    6 years ago

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

  • 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