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 

 

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

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Thank you so much VahidDM 
        Seems to be working fine. But I couldn't understand why it gives a different result in the crossed out one in the picture below.