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

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.

       

       

      • VahidDM's avatar
        VahidDM
        Super User
        4 years ago

        Anonymous 

         

        Because of the different aggregation you set for that column (for e.g. Earlier) and the MAX formula you used in the measure.

         

        Appreciate your Kudos!!