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

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