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!!

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hello VahidDM 

 

Thank you for reply. 
It did not happen. Or I did something wrong 😞

 

Miro Tarih2 =
LOOKUPVALUE (Miro[Fatura Tarihi],Miro[Fatura Tarihi],'Detailed DED Analysis'[DocumentDate]
)
-MAX('Detailed DED Analysis'[DocumentDate])
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: