Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Date Difference between 2 different tables

Hello,   I want calculate Date Difference between 2 different tables. I think I did but i have two problem. 1-) that but it gives wrong result when calculating same days.   I use this:  ...
Need Help
  • VahidDM's avatar
    VahidDM
    4 years ago

    Try this:

    Measure = DATEDIFF(max('Detailed DED Analysis'[DocumentDate]),max(Miro[Fatura Tarihi]),DAY)

     

    Output:

     

     

    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

    Appreciate your Kudos!!

     

VahidDM's avatar
VahidDM
Super User
4 years ago

Hi Anonymous 

 

Is there any relashionship between your tables?

Can you share a sample of your data?

 

Appreciate your Kudos!!

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hello VahidDM 

 

deleted.

 

Thank you!

  • VahidDM's avatar
    VahidDM
    Super User
    4 years ago

    Anonymous 

     

    Each Document Number in Miro table has many dates, which onr do you want to use in the calculation?

     

    Appreciate your Kudos!!

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi VahidDM 

       

      I want the calculate to be like this: Detailed DED Analysis'[DocumentDate] - Miro[Fatura Tarihi]

      (first Fatura Tarihi dates) that is, the earliest "Fatura Tarihi" belongs to that Document number. VahidDM 

       

      like this:

       

       

       

      • VahidDM's avatar
        VahidDM
        Super User
        4 years ago

        Try this:

        Measure = DATEDIFF(max('Detailed DED Analysis'[DocumentDate]),max(Miro[Fatura Tarihi]),DAY)

         

        Output:

         

         

        If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

        Appreciate your Kudos!!